循环sql

declare @a int
set @a=10000
while @a<=11000
begin
SELECT * FROM [gmccold].[dbo].[cvv_Users] where workid<>'' and  workid=@a
set @a=@a+1
end
posted on 2007-06-12 09:59  心悦  阅读(255)  评论(0编辑  收藏  举报