sql server 2005中如何使用指针循环读取数据

来源:互联网 发布:阿里云输入法apk 编辑:程序博客网 时间:2024/06/05 09:37

declare @name nvarchar(50);
DECLARE Employee_Cursor CURSOR FOR
SELECT [name] FROM sysobjects where xtype='u';
OPEN Employee_Cursor;
--FETCH NEXT FROM Employee_Cursor into @name;
WHILE @@FETCH_STATUS = 0
   BEGIN
        FETCH NEXT FROM Employee_Cursor into @name;
        print @name;
   END;
CLOSE Employee_Cursor;
DEALLOCATE Employee_Cursor;
GO

原创粉丝点击