Professional Web Applications Themes

To Use Update Cursor or something else - Microsoft SQL / MS SQL Server

I am rewriting some code that I want to run in stored procedures. The gist is to cycle through a work table and update several fields for each record based upon what is determined by other fields. (There is only about 10 fields in my table) I don't know alot about cursors. But should I use one to cycle through and can I update the values in each field & record via a Cursor? Could someone give me a basic example? Or should I avoid cursors? If I should that what should I use? Is it possible to do a ...

  1. #1

    Default To Use Update Cursor or something else

    I am rewriting some code that I want to run in stored procedures. The
    gist is to cycle through a work table and update several fields for each
    record based upon what is determined by other fields. (There is only
    about 10 fields in my table)

    I don't know alot about cursors. But should I use one to cycle through
    and can I update the values in each field & record via a Cursor? Could
    someone give me a basic example?

    Or should I avoid cursors? If I should that what should I use? Is it
    possible to do a Select into multiple variables so each field is
    represented by a variable that I can yze? I know how to do a
    SET MyVar = (SELECT FieldName from mytable)
    which sets 1 variable for 1 field, but how do you do this for multiple
    variables and multiple fields?

    THanks for any advice
    -Colin



    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Colin Guest

  2. #2

    Default Re: To Use Update Cursor or something else

    > I don't know alot about cursors. But should I use one to cycle through 

    Cursors are much slower than straight update queries, but depending on the
    amount of data and weather a user is waiting for it to complete vs. an
    overnight batch job will be the bigger deciding factors.

    There are some examples in the books online, RTFM. (maybe someone with more
    time can post a concise example).

    Regards,

    Glen Starrett


    Glen Guest

  3. #3

    Default Re: To Use Update Cursor or something else

    Cursors have their place in sqlserver. However, it's always better to do
    things as set-based.

    If you provide ddl (create table) + sample data (insert) + expected output,
    someone here might be able to give a solution.

    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net


    "Colin Colin" <guthrie.org> wrote in message
    news:#phx.gbl... 


    oj Guest

Similar Threads

  1. [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.
    By Mariano Fernandao in forum ASP.NET Web Services
    Replies: 0
    Last Post: December 10th, 06:30 PM
  2. 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
  3. Replies: 0
    Last Post: July 16th, 07:00 AM
  4. Replies: 0
    Last Post: July 16th, 04:09 AM

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