sql server 2000 游标用法小例

sql server 2000 游标用法小例(5) BEGIN
 
SELECT @message = '         ' + @product
PRINT @message
FETCH NEXT FROM product_cursor INTO @product
 
END
 
CLOSE product_cursor
DEALLOCATE product_cursor
 
-- Get the next vendor.
FETCH NEXT FROM vendor_cursor 
INTO @vendor_id, @vendor_name
END 
CLOSE vendor_cursor
DEALLOCATE vendor_cursor