SqlServer游标操作

CLOSE orderNum_02_cursor
deallocate orderNum_02_cursor
DECLARE orderNum_02_cursor cursor SCROLL for select vcThemeId from LG_LiveTheme_Order
DECLARE @themeid varchar(10)
OPEN orderNum_02_cursor
fetch first from orderNum_02_cursor INTO @themeid
WHILE @@FETCH_STATUS=0
BEGIN
PRINT @themeid
FETCH NEXT FROM orderNum_02_cursor INTO @themeid
END

CLOSE orderNum_02_cursor
deallocate orderNum_02_cursor

SqlServer游标操作

标签：dealloc   sqlserver   order   begin   print   server   lse   serve   fetch