The syntax of the DECLARE CURSOR statement : Declare Cursor « Cursor « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Cursor
  3. Declare Cursor
DECLARE cursor_name CURSOR
    [LOCAL|GLOBAL]
    [FORWARD_ONLY|SCROLL]
    [FAST_FORWARD|STATIC|KEYSET|DYNAMIC]
    [READ_ONLY|SCROLL_LOCKS|OPTIMISTIC]
FOR select_statement
    [FOR UPDATE [OF column_name [, ...]]]








18.2.Declare Cursor
18.2.1.The syntax of the DECLARE CURSOR statement
18.2.2.A DECLARE CURSOR statement that declares a dynamic local cursor
18.2.3.A cursor created in SQL server.
18.2.4.INSENSITIVE Cursor
18.2.5.Cursor on a Single-Column Key
18.2.6.Four cursors
18.2.7.Declare a cursor variable to hold the cursor output variable
18.2.8.Local scroll cursor
18.2.9.DECLARE CURSOR FAST_FORWARD FOR
18.2.10.DECLARE cursor LOCAL
18.2.11.DECLARE CURSOR GLOBAL FOR
18.2.12.Static cursor