根据条件查询得到结果集,利用游标循环遍历得到结果集,向另一表插入得到结果集
–游标
use sqlXinyongK
go
declare stu_cursor cursor scroll
for select age,stuname from stu where sex=’女’
open stu_cursor
declare @stuname varchar(50)
declare @age varchar(50)
fetch first from stu_cursor into @age,@stuname
while @@FETCH_STATUS = 0
begin
insert into [sqlXinyongK].[dbo].[Stu] (stuname,age,sex) values (@stuname,@age,’女’)
fetch next from stu_cursor into @age,@stuname
end
close stu_cursor
deallocate stu_cursor
游标循环遍历结果集,向另一表插入结果集
最新推荐文章于 2023-09-12 15:40:54 发布