Professional Web Applications Themes

Dynamic Proc Parameters - Microsoft SQL / MS SQL Server

Ugh, don't bother using a proc. "MattM" <mcdba_seahotmail.com> wrote in message news:019b01c33f3e$b83a3310$a501280aphx.gbl... > What is the best way to pass SQL PROC > parameters to a SELECT when you don't know > how many columns need to be selected. > > Example. Query 1 col1, col2, col3 > Query 2 col1, col2 > >...

  1. #1

    Default Re: Dynamic Proc Parameters

    Ugh, don't bother using a proc.


    "MattM" <mcdba_seahotmail.com> wrote in message
    news:019b01c33f3e$b83a3310$a501280aphx.gbl...
    > What is the best way to pass SQL PROC
    > parameters to a SELECT when you don't know
    > how many columns need to be selected.
    >
    > Example. Query 1 col1, col2, col3
    > Query 2 col1, col2
    >
    >

    Aaron Bertrand - MVP Guest

  2. #2

    Default Re: Dynamic Proc Parameters

    Please read:
    [url]http://www.algonet.se/~sommar/dynamic_sql.html[/url]


    "MattM" <mcdba_seahotmail.com> wrote in message
    news:019b01c33f3e$b83a3310$a501280aphx.gbl...
    > What is the best way to pass SQL PROC
    > parameters to a SELECT when you don't know
    > how many columns need to be selected.
    >
    > Example. Query 1 col1, col2, col3
    > Query 2 col1, col2
    >
    >

    Aaron Bertrand - MVP Guest

Similar Threads

  1. Adding Dynamic User Control WITH PARAMETERS
    By Jason Chu in forum ASP.NET Building Controls
    Replies: 0
    Last Post: July 14th, 06:45 PM
  2. LoadVars with dynamic parameters problem
    By dmalis webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 3
    Last Post: January 18th, 10:10 PM
  3. create parameters without creating parameters
    By dan marks in forum ASP Components
    Replies: 0
    Last Post: October 30th, 01:51 AM
  4. ASP vs Stored Proc vs UDF
    By Brad in forum ASP Database
    Replies: 11
    Last Post: October 28th, 01:46 AM
  5. stored proc and tcp/ip
    By Helmut Wöss in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: June 30th, 08:13 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