declare @a varchar(10),@b varchar(10),@c varchar(10),@d varchar(10)
DECLARE del_cursor CURSOR FOR
SELECT * FROM #t2
OPEN del_cursor
FETCH NEXT FROM del_cursor into @a,@b,@c,@d
WHILE @@FETCH_STATUS = 0
BEGIN
print @a +' '+@b
FETCH NEXT FROM del_cursor into @a,@b,@c,@d
END
CLOSE del_cursor
DEALLOCATE del_cursor
cursor
最新推荐文章于 2023-03-29 16:44:47 发布