Professional Web Applications Themes

Which columns are returned by a SP ? - Microsoft SQL / MS SQL Server

Hi all. I'm trying to write some code that would list all the result sets and respective columns returned by any given stored procedure. Is there a way to do this through sys tables or sp's ? I'm trying to avoid having to call the desired SP and loop through the returned result sets and their columns. I'm programming in .net but a VB6 solution may be fine. Any tips ? Thanks TJ...

  1. #1

    Default Which columns are returned by a SP ?

    Hi all.
    I'm trying to write some code that would list all the result sets and
    respective columns returned by any given stored procedure.
    Is there a way to do this through sys tables or sp's ? I'm trying to avoid
    having to call the desired SP and loop through the returned result sets and
    their columns. I'm programming in .net but a VB6 solution may be fine.

    Any tips ?

    Thanks

    TJ


    TJoker Guest

  2. #2

    Default Re: Which columns are returned by a SP ?

    you could use SQL Profiler to see what VS is actually doing. I suspect it's
    simply calling some catalouge procs that may not be doc'd. You should be
    ablet to call them as well or at least look at the SQL and build from
    thier....

    --

    Brian Moran
    Principal Mentor
    Solid Quality Learning
    SQL Server MVP
    http://www.solidqualitylearning.com


    "TJoker .NET" <no> wrote in message
    news:phx.gbl... 
    drop [/ref]
    not 
    > So, 
    > T-SQL [/ref]
    > avoid [/ref][/ref]
    sets 
    > >
    > >[/ref]
    >
    >[/ref]


    Brian Guest

  3. #3

    Default Re: Which columns are returned by a SP ?

    That's what I did before my last post.

    "Brian Moran" <com> wrote in message
    news:phx.gbl... 
    it's [/ref]
    Studio 
    > drop [/ref]
    returned [/ref]
    sets. [/ref][/ref]
    a [/ref]
    > not 
    > > So, 
    > > T-SQL [/ref][/ref]
    and 
    > > avoid [/ref]
    > sets [/ref][/ref]
    fine. 
    > >
    > >[/ref]
    >
    >[/ref]


    TJoker Guest

Similar Threads

  1. Replies: 3
    Last Post: November 19th, 07:34 PM
  2. using value returned from last command
    By ChrisC in forum Linux / Unix Administration
    Replies: 2
    Last Post: September 16th, 11:54 AM
  3. Columns and Inherited Datagrid...Active Schema does not support columns
    By rob thomson in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: September 4th, 03:09 PM
  4. SP returned recordsets
    By Saul in forum Microsoft SQL / MS SQL Server
    Replies: 6
    Last Post: July 13th, 10:10 PM
  5. Replies: 0
    Last Post: July 2nd, 06:18 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