简单游标

DECLARE Employee_Cursor CURSOR FORSELECT top 20 sal_sales, sales_name,sal_team FROM sal_a_sales where sal_group=16OPEN Employee_CursorFETCH NEXT FROM Employee_CursorWHILE @@FETCH_STATUS = 0BEGINFETCH

weixin_34198583

81人浏览 · 2012-11-27 11:06:00

weixin_34198583 · 2012-11-27 11:06:00 发布

DECLARE Employee_Cursor CURSOR FOR
SELECT top 20 sal_sales, sales_name,sal_team FROM sal_a_sales where sal_group=16
OPEN Employee_Cursor
FETCH NEXT FROM Employee_Cursor
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM Employee_Cursor
END
CLOSE Employee_Cursor
DEALLOCATE Employee_Cursor

转载于:https://www.cnblogs.com/streetpasser/archive/2012/11/27/2790392.html

AI编程社区

汇聚全球AI编程工具，助力开发者即刻编程。

更多推荐