SQL Server for循环
来源:百度知道 编辑:UC知道 时间:2024/09/22 12:47:11
insert into cms_count values('192.168.1.174','1','狗狗','http://gougou.com/','1280*780','IE','Vasta','www.163.com','2007-12-12')
时间要更改
我要循环插入。插到.2008-9-10 . 是
在SQL查询分析器里面怎么插入
时间要更改
我要循环插入。插到.2008-9-10 . 是
在SQL查询分析器里面怎么插入
你是每天插一条这样的数据吗
declare @num int
declare @datediff int
select @datediff=datediff(day,'2007-12-12','2008-9-10)
set @num=0
while @num<@datediff
begin
insert into cms_count values('192.168.1.174','1','狗狗','http://gougou.com/','1280*780','IE','Vasta','www.163.com',dateadd(day,@num,'2007-12-12') )
set @num=@num+1
end
Microsofr SQL Server 2000 Drive for JDBC
microsoft ole db provider for sql server 错误‘ 80004005’
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Microsoft OLE DB Provider for SQL Server (0x80004005)
Microsoft OLE DB Provider for SQL Server (0x80040E14)错误
Microsoft OLE DB Provider for SQL Server '80004005'
C#程序连接sql server数据库问题??thankyou for everything
SQL Server ?
sql server
SQL server???