Professional Web Applications Themes

Question on EXEC () - Microsoft SQL / MS SQL Server

Is it possible to capture the output of a EXEC() statement into a variable ? I construct a dynamic sql which returns a single value (SELECT count(*) from X) and I execute this sql using EXEC. So is there anyway I can assign the count (*) value to a local variable ? Or any other suggestions for this issue ? Thanks for your time....

  1. #1

    Default Question on EXEC ()

    Is it possible to capture the output of a EXEC() statement
    into a variable ? I construct a dynamic sql which returns
    a single value (SELECT count(*) from X) and I execute this
    sql using EXEC. So is there anyway I can assign the count
    (*) value to a local variable ? Or any other suggestions
    for this issue ? Thanks for your time.
    exBK Guest

  2. #2

    Default Re: Question on EXEC ()

    Chikkodi,

    See if this helps..

    INF: Using Output Parameters with sp_executesql
    [url]http://support.microsoft.com/?id=262499[/url]


    --
    Dinesh.
    SQL Server FAQ at
    [url]http://www.tkdinesh.com[/url]

    "exBK" <chikkodi> wrote in message
    news:0b5a01c33f4e$35ea1c80$a001280aphx.gbl...
    > Is it possible to capture the output of a EXEC() statement
    > into a variable ? I construct a dynamic sql which returns
    > a single value (SELECT count(*) from X) and I execute this
    > sql using EXEC. So is there anyway I can assign the count
    > (*) value to a local variable ? Or any other suggestions
    > for this issue ? Thanks for your time.

    Dinesh.T.K Guest

  3. #3

    Default Question on EXEC ()

    declare intCount int
    set intCount = (Select count(*) from X)
    print intCount

    Ricky
    >-----Original Message-----
    >Is it possible to capture the output of a EXEC()
    statement
    >into a variable ? I construct a dynamic sql which returns
    >a single value (SELECT count(*) from X) and I execute
    this
    >sql using EXEC. So is there anyway I can assign the count
    >(*) value to a local variable ? Or any other suggestions
    >for this issue ? Thanks for your time.
    >.
    >
    Ricky Guest

Similar Threads

  1. exec()
    By manu in forum PHP Development
    Replies: 6
    Last Post: July 13th, 09:53 PM
  2. question on find -exec
    By Lu in forum Linux / Unix Administration
    Replies: 3
    Last Post: December 9th, 03:25 PM
  3. SSH and EXEC problem
    By Frederic Lhoest in forum PHP Development
    Replies: 0
    Last Post: September 16th, 02:17 PM
  4. How to exec PHP as CGI
    By Lowell Allen in forum PHP Development
    Replies: 0
    Last Post: August 27th, 08:49 PM
  5. Replies: 0
    Last Post: December 10th, 09:27 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