SQL Server Performance Forum – Threads Archive
Passing parameter listHi, 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 —
Microsoft SQL Server MVP
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.