SQL FETCH 迴圈架構

範例
http://pastie.org/4312553

FETCH 的架構如下

DECLARE Table_Cursor CURSOR FOR
SELECT [Table],[boxid],[lineid]
FROM [MotoTRAK01].[dbo].[tbl_VIP_Accessories_Reference]
where fgpn = @PartNumber
OPEN Table_Cursor
FETCH NEXT FROM Table_Cursor
WHILE @@FETCH_STATUS = 0
   BEGIN 
     FETCH NEXT FROM Table_Cursor into @tablename,@boxid,@line
   END
CLOSE Table_Cursor
DEALLOCATE Table_Cursor