Create Table H4 (ccc int,date datetime)
Declare @i int
set @i=1
while @i<50
begin
insert into H4
select 200,'2004-12-1'
set @i=@i+1
end
-----------------上面是建測試數據----------------
--------------下面是實現語句--------------------
Declare @p int
set @p=0
update H4 set ccc=@p,@p=@p+50
----------結果-------------------------
50 2004-12-01 00:00:00.000
100 2004-12-01 00:00:00.000
150 2004-12-01 00:00:00.000
200 2004-12-01 00:00:00.000
250 2004-12-01 00:00:00.000
.................................
.......
Declare @i int
set @i=1
while @i<50
begin
insert into H4
select 200,'2004-12-1'
set @i=@i+1
end
-----------------上面是建測試數據----------------
--------------下面是實現語句--------------------
Declare @p int
set @p=0
update H4 set ccc=@p,@p=@p+50
----------結果-------------------------
50 2004-12-01 00:00:00.000
100 2004-12-01 00:00:00.000
150 2004-12-01 00:00:00.000
200 2004-12-01 00:00:00.000
250 2004-12-01 00:00:00.000
.................................
.......
--------------下面是實現語句--------------------
Declare @p int
set @p=0
update H4 set ccc=@p,@p=@p+50 WHERE date = '2004-12-1' ----這加where條件
----------結果-------------------------
50 2004-12-01 00:00:00.000
100 2004-12-01 00:00:00.000
150 2004-12-01 00:00:00.000
200 2004-12-01 00:00:00.000
250 2004-12-01 00:00:00.000
while i<=2500
begin
update H4 set ccc='要修改的值'
i=i+50
end
begin
update table set ccc=''
i = i + 50
end
游标循环,update ccc 为 50, 100 ……