sql存儲過程的while循環

alter procedure time_by
as
Declare @Count Int
Set @Count=1099
While @Count<=4298   --@Count的初值为1099,自然不会大于等于4298,while循环也自然不会执行
Begin
    update Time_by_day set Time_ID=(@Count-1098) where Time_ID=@Count
    Set @Count=@Count+1
End
Go

執行該存儲過程:
execute time_by
posted @ 2006-11-23 14:23  Nina  阅读(4455)  评论(1编辑  收藏  举报