SQL Server Performance Forum – Threads Archive

Passing parameter list

Hi, everyone. I have been passing list of data in xml format to stored procedure as ntext. The stored procedure than parses the xml and gets the values. Can anybody please suggest me a faster option in passing the list of data as parameters to stored procedures or in any other way. Thanks in advance.

See if this helps:http://www.sommarskog.se/arrays-in-sql.html —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Thanks again Frank. That is just what I needed. The article was very helpful.

]]>