Professional Web Applications Themes

Cursor Question - Microsoft SQL / MS SQL Server

There are some options following that matter. Check out BOL for "SET local_variable" -- Dean Savovic www.teched.hr "Venkatesan M" <com> wrote in message news:%phx.gbl... ...

  1. #1

    Default Re: Cursor Question

    There are some options following that matter.

    Check out BOL for "SET local_variable"

    --
    Dean Savovic
    www.teched.hr


    "Venkatesan M" <com> wrote in message news:%phx.gbl... 


    Dean Guest

  2. #2

    Default Re: Cursor Question

    I'm not sure if this answers your question, but you can use cursor variables, and even passing them as output parameters from a stored procedure.

    Here's an example from BOL, under "Scope of Transact-SQL Cursor Names":

    USE pubs
    GO
    /* Create a procedure with a cursor output parameter. */
    CREATE PROCEDURE OpenCrsr OutCrsr CURSOR VARYING OUTPUT AS

    SET OutCrsr = CURSOR FOR
    SELECT au_lname
    FROM authors
    WHERE au_lname LIKE 'S%'

    OPEN OutCrsr
    GO

    /* Allocate a cursor variable. */
    DECLARE CrsrVar CURSOR

    /* Execute the procedure created earlier to fill
    the variable. */
    EXEC OpenCrsr OutCrsr = CrsrVar OUTPUT

    /* Use the variable to fetch the rows from the cursor. */
    FETCH NEXT FROM CrsrVar
    WHILE (FETCH_STATUS <> -1)
    BEGIN
    FETCH NEXT FROM CrsrVar
    END

    CLOSE CrsrVar

    DEALLOCATE CrsrVar
    GO-- BG, SQL Server MVPSolid Quality Learningwww.solidqualitylearning.com

    "Venkatesan M" <com> wrote in message news:#phx.gbl... 
    Itzik Guest

  3. #3

    Default Cursor Question

    hi folks,
    Is there any way to assign a cursor to another cursor like how we assign a
    variables value to another variable...
    thanks in advance


    Venkatesan Guest

  4. #4

    Default Re: Cursor Question

    You can have several references to the same local cursor.

    DECLARE TableCursor cursor
    DECLARE Cursor2 cursor
    DECLARE TableName sysname
    SET TableCursor = CURSOR FOR SELECT name FROM dbo.sysobjects WHERE type =
    'U' ORDER BY name
    SET Cursor2 = TableCursor

    OPEN Cursor2
    FETCH NEXT FROM Cursor2 INTO TableName
    WHILE FETCH_STATUS = 0
    BEGIN
    PRINT TableName
    FETCH NEXT FROM Cursor2 INTO TableName
    END


    "Venkatesan M" <com> wrote in message
    news:#phx.gbl... 


    Anthony Guest

Similar Threads

  1. look at the cursor
    By Seph webforumsuser@macromedia.com in forum Macromedia Director 3D
    Replies: 2
    Last Post: December 18th, 01:56 PM
  2. Ruby/Tk Cursor Selection Question
    By Zach Dennis in forum Ruby
    Replies: 1
    Last Post: November 11th, 09:48 PM
  3. Programming Question: Open Cursor failed ,why ?
    By Jonathan Leffler in forum Informix
    Replies: 0
    Last Post: August 23rd, 08:31 AM
  4. cursor 200-problem on mac but not pc? how to swap cursor image?
    By nickelsock webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 5
    Last Post: August 2nd, 10:58 AM
  5. Change the "web hand" cursor in normal arrow cursor?
    By FB1976 in forum Adobe Dreamweaver & Contribute
    Replies: 1
    Last Post: July 9th, 07:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139