SQL Server 游标遍历表

DECLARE @id INT
DECLARE myCursor CURSOR FOR SELECT id FROM emm.StockOutBill WHERE stockOutSourceTypeId=506 AND stockOutSourceId=@applyId
OPEN myCursor
FETCH NEXT FROM myCursor INTO @id
WHILE @@FETCH_STATUS=0
BEGIN
PRINT @id
DECLARE @StockOutBillCode NVARCHAR(50)
exec  [emm].[P_GetEmmNumber] 'StockOutBill',@StockOutBillCode output
UPDATE emm.StockOutBill SET [code]=@StockOutBillCode WHERE [id]=@id
FETCH NEXT FROM myCursor INTO @id
END
CLOSE myCursor
DEALLOCATE myCursor