如何看游标里有什么记录

[reanna]

--声明游标变量
DECLARE
@priority int,
@vendor_id varchar(10)

DECLARE vendor_cursor CURSOR FOR
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
WHILE @@FETCH_STATUS=0
BEGIN
UPDATE wh_vendor_pay_info SET priority=0 WHERE (trans=0) AND (vendor_id<>@vendor_id)

FETCH vendor_cursor
INTO @vendor_id,@priority
END

--关闭游标
CLOSE vendor_cursor
--释放游标
DEALLOCATE vendor_cursor

－－－－－－－－－－－－－－－－

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是什么值？



















FETCH vendor_cursor
INTO @vendor_id,@priority
END

--关闭游标
CLOSE vendor_cursor
--释放游标
DEALLOCATE vendor_cursor

[CrazyFor]

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

[愉快的登山者]

select @vendor_id,@priority

[pengdali]

如：

declare cursor_insert cursor for select c# from cs
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

[hjb111]

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是什么值？
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

[xah_JD]

print @vendor_id
print @priority