复制代码 代码如下:

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