sql 游标使用笔记

复制代码 代码如下:

declare @pdtid nvarchar(50)

declare @ptype nvarchar(50)

declare my_cursor cursor for

select pdtid,ptype from dbo.product

open my_cursor

fetch next from my_cursor

into @pdtid,@ptype

while @@fetch_status=0

begin

fetch next from my_cursor

end

close my_cursor