游标读表插入

declare @LoginName nvarchar(50)
declare @LoginPwd nvarchar(50)
declare @Name nvarchar(50)
declare @Age int
declare @Sex int
declare @Count int

declare My_Cursor cursor for
SELECT
[LoginName]
,[LoginPwd]
,[Name]
,[Age]
,[Sex]
FROM [Sp].[dbo].[Users]
open My_Cursor
fetch next from My_Cursor into @LoginName,@LoginPwd,@Name,@Age,@Sex

while (@@fetch_status=0) --提取成功，进行下一条数据的提取操作
begin
set @Count=(SELECT count(*) FROM [Sp].[dbo].[Users])
if(@Count<1000)
begin
insert into [Users] values(@LoginName,@LoginPwd,@Name,@Age,@Sex);
end
fetch next from My_Cursor into @LoginName,@LoginPwd,@Name,@Age,@Sex --移动游标
end
close My_Cursor
deallocate My_Cursor