复制代码 代码如下: 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 fet
复制代码 代码如下: 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