764      阿里云  技术社区[云栖]

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

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

最后更新：2017-04-02 04:00:23

  上一篇： 关于如何使用String.IndexOf 方法（C#）

  下一篇： 文本框获取焦点并弹出下拉框