passing array to stored procedure

[Guest]

hi al
can u plz give me an example to passing array to stored procedure for sql serve
than
Mukunda

 

[Miha Markic [MVP C#]]

Hi,

You can't pass an array and sql server procedure doesn't support an array
parameters afaik.

 

[Scott Allen]

Here is a comprehensive article on the subject:
http://www.algonet.se/~sommar/arrays-in-sql.html

It's not a 'built in' feature as yet, so will require some design and
trade off evaluations.

HTH.

 

[William Ryan eMVP]

Miha's right, you can't pass an array directly, but if you are up for a
little work around.. this
http://www.knowdotnet.com/articles/temptables.html should get you through
it.

HTH,

Bill

 

[Guest]

You can pass in an XML structure that could contain the rows/columns that would mimic the array. The XML below could be cleaned up, but this is just what was thrown together

DECLARE @xml nvarchar(1000)
@docHandle in

SET @xml =
'<root><clients><client><clientid>5</clientid><name>bob</name></client><client><clientid>6</clientid><name>josh</name></client></clients></root>

EXEC sp_xml_preparedocument @docHandle OUTPUT, @xml

SELEC
clientid
nam
FROM
OPENXML (@docHandle, '/root/clients/client',2) WITH (clientid int
name nvarchar(25))
EXEC sp_xml_removedocument @docHandle

hth

 

[Guest]

hi
Thanks for all reply you have given me .I will work on it
regards
Mukunda



----- William Ryan eMVP wrote: -----

Miha's right, you can't pass an array directly, but if you are up for a
little work around.. this
http://www.knowdotnet.com/articles/temptables.html should get you through
it.

HTH,

Bill

 

[Miha Markic [MVP C#]]

See also this link:
http://www.sommarskog.se/arrays-in-sql.html