SELECT vendor_id,priority FROM wh_vendor_pay_info WHERE trans=1 AND priority=0
OPEN vendor_cursor
FETCH FROM vendor_cursor
INTO @vendor_id,@priority--如何看看此时游标中@vendor_id,@priority是什么值?
print 'Vendor:'+ cast(@vendor_id as varchar)
print 'Priority:'+cast(@priority as varchar(1000)
FETCH vendor_cursor
INTO @vendor_id,@priority
END--关闭游标
CLOSE vendor_cursor
--释放游标
DEALLOCATE vendor_cursor
OPEN vendor_cursor
FETCH FROM vendor_cursor
INTO @vendor_id,@priority--如何看看此时游标中@vendor_id,@priority是什么值?
print 'Vendor:'+ cast(@vendor_id as varchar)
print 'Priority:'+cast(@priority as varchar(1000)
FETCH vendor_cursor
INTO @vendor_id,@priority
END--关闭游标
CLOSE vendor_cursor
--释放游标
DEALLOCATE vendor_cursor
declare @i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
print @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
OPEN vendor_cursor
FETCH FROM vendor_cursor
INTO @vendor_id,@priority--如何看看此时游标中@vendor_id,@priority是什么值?
while @@fetch_status=0
begin
print @vendor_id
print @priority
end
FETCH vendor_cursor
INTO @vendor_id,@priority
END--关闭游标
CLOSE vendor_cursor
--释放游标
DEALLOCATE vendor_cursor
print @priority