Professional Web Applications Themes

cursor or 2 selects - Microsoft SQL / MS SQL Server

You are fetching 2 variables from the same row. In other words is your where statement returning only one row? If so: select variable1 = field1, variable2 = field2 from table1 where id = ... Avoid cursors!!! -- Dean Savovic [url]www.teched.hr[/url] "Gerhard Kashofer" <gerhard.kashoferesa-at.at> wrote in message news:027401c33ed7$f67c5520$a001280aphx.gbl... > Hi, > i want to read two fields of a specified row of a table > into 2 variables. > Is it better to declare a cursor and read both fields > into the variables within a single select or not using a > cursor and read both fields using 2 ...

  1. #1

    Default Re: cursor or 2 selects

    You are fetching 2 variables from the same row. In other words is your where
    statement
    returning only one row?

    If so:

    select variable1 = field1, variable2 = field2
    from table1
    where id = ...

    Avoid cursors!!!

    --
    Dean Savovic
    [url]www.teched.hr[/url]


    "Gerhard Kashofer" <gerhard.kashoferesa-at.at> wrote in message
    news:027401c33ed7$f67c5520$a001280aphx.gbl...
    > Hi,
    > i want to read two fields of a specified row of a table
    > into 2 variables.
    > Is it better to declare a cursor and read both fields
    > into the variables within a single select or not using a
    > cursor and read both fields using 2 select- statements
    > Method1:
    > declare variable1 int
    > declare variable2 int
    >
    > declare cur1 cursor for
    > select field1, field2
    > FROM table1
    > where id = ...
    >
    > open cur1
    > fetch next from cur1 into variable1, variable2
    >
    > if fetch_status = 0
    > begin
    > ...
    > end
    >
    > close cur1
    > deallocate cur1
    >
    > Method2:
    > declare variable1 int
    > declare variable2 int
    >
    > Set variable1 = (select field1
    > FROM table1
    > where id = ...)
    >
    > Set variable2 = (select field2
    > FROM table1
    > where id = ...)
    >
    > ...

    Dean Savovic Guest

  2. #2

    Default Re: cursor or 2 selects

    You can do this with a single SELECT.

    SELECT variable1 = col1, variable2 = col2
    FROM table1
    WHERE id = ...

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "Gerhard Kashofer" <gerhard.kashoferesa-at.at> wrote in message
    news:027401c33ed7$f67c5520$a001280aphx.gbl...
    > Hi,
    > i want to read two fields of a specified row of a table
    > into 2 variables.
    > Is it better to declare a cursor and read both fields
    > into the variables within a single select or not using a
    > cursor and read both fields using 2 select- statements
    > Method1:
    > declare variable1 int
    > declare variable2 int
    >
    > declare cur1 cursor for
    > select field1, field2
    > FROM table1
    > where id = ...
    >
    > open cur1
    > fetch next from cur1 into variable1, variable2
    >
    > if fetch_status = 0
    > begin
    > ...
    > end
    >
    > close cur1
    > deallocate cur1
    >
    > Method2:
    > declare variable1 int
    > declare variable2 int
    >
    > Set variable1 = (select field1
    > FROM table1
    > where id = ...)
    >
    > Set variable2 = (select field2
    > FROM table1
    > where id = ...)
    >
    > ...

    David Portas Guest

Similar Threads

  1. 2 selects related
    By Swd1974 in forum Macromedia ColdFusion
    Replies: 0
    Last Post: June 16th, 06:01 PM
  2. SQL: nested select vs. two selects
    By darrel in forum Adobe Dreamweaver & Contribute
    Replies: 2
    Last Post: April 28th, 03:42 PM
  3. CFselect with multiple selects
    By Frank Farning in forum Macromedia ColdFusion
    Replies: 1
    Last Post: March 27th, 10:46 PM
  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. How to count record selects?
    By TimC in forum Oracle Server
    Replies: 3
    Last Post: December 19th, 09:37 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