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#）

  下一篇： 文本框獲取焦點並彈出下拉框