Professional Web Applications Themes

Passing Array as a parameter - Microsoft SQL / MS SQL Server

Hi all, How do I pass a array as a parameter to a stored procudure can I have a sample?? TIA Kishor...

  1. #1

    Default Passing Array as a parameter

    Hi all,
    How do I pass a array as a parameter to a stored procudure can I have a
    sample??
    TIA
    Kishor


    Kishor Guest

  2. #2

    Default Re: Passing Array as a parameter

    Hi,

    SQL doesn't support this. But maybe you want to take a look at this:
    http://www.eggheadcafe.com/articles/20001002.asp
    http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

    hope this help
    Bjoern Wolfgardt

    "Kishor" <com> schrieb im Newsbeitrag
    news:phx.gbl... 


    Bjoern Guest

  3. #3

    Default Re: Passing Array as a parameter

    Kishor,

    Also make sure you check out the following article by Erland Sommarskog:

    http://www.algonet.se/~sommar/arrays-in-sql.html

    --
    BG, SQL Server MVP
    Solid Quality Learning
    www.solidqualitylearning.com


    "Kishor" <com> wrote in message
    news:phx.gbl... 


    Itzik Guest

  4. #4

    Default Re: Passing Array as a parameter

    Passing arrays to stored procedure

    http://www.algonet.se/~sommar/arrays-in-sql.html


    --
    -Vishal
    Kishor <com> wrote in message
    news:phx.gbl... 


    Vishal Guest

  5. #5

    Default Re: Passing Array as a parameter

    You can use sql-server XML support, like this:

    declare xml nvarchar(1024)

    set xml = '<array><elem id="0">val0</elem>...<elem
    id="n">valn</elem></array>'
    exec sp_name xml

    Ruggero

    "Kishor" <com> ha scritto nel messaggio
    news:phx.gbl... 


    Ruggero Guest

Similar Threads

  1. Passing URL parameter
    By MarkMeerten in forum Dreamweaver AppDev
    Replies: 14
    Last Post: June 29th, 08:28 AM
  2. Passing a parameter in SWF
    By Kesab in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: March 11th, 03:33 PM
  3. Passing in a parameter
    By Jon in forum ASP.NET Building Controls
    Replies: 3
    Last Post: February 9th, 03:39 PM
  4. getURL parameter passing bug?
    By 1dan webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 3
    Last Post: February 3rd, 06:22 PM
  5. parameter passing from asp to php
    By PIII450@HOME.NL in forum PHP Development
    Replies: 3
    Last Post: December 4th, 02:39 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