读书人

游标的应用简单示例

发布时间: 2012-08-16 12:02:15 作者: rapoo

游标的使用,简单示例

DECLARE
Employee_Cursor
CURSOR FOR SELECT top 2 usr_code,usr_desc FROM r5users
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

读书人网 >其他数据库

热点推荐