create table tb(dt datetime)
insert into tb select '2008-1-8'
insert into tb select '2008-1-8'
insert into tb select '2008-1-8'
insert into tb select '2008-1-8'
insert into tb select '2008-1-8'declare @s int
set @s=0
update tb set dt=dateadd(s,@s,dt),@s=@s+1 from tb
select * from tb2008-01-08 00:00:01.000
2008-01-08 00:00:02.000
2008-01-08 00:00:03.000
2008-01-08 00:00:04.000
2008-01-08 00:00:05.000
insert into tb select '2008-1-8'
insert into tb select '2008-1-8'
insert into tb select '2008-1-8'
insert into tb select '2008-1-8'
insert into tb select '2008-1-8'declare @s int
set @s=0
update tb set dt=dateadd(s,@s,dt),@s=@s+1 from tb
select * from tb2008-01-08 00:00:01.000
2008-01-08 00:00:02.000
2008-01-08 00:00:03.000
2008-01-08 00:00:04.000
2008-01-08 00:00:05.000
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货