Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 array of parameters in sp

Author  Topic 

mmdullah
Starting Member

10 Posts

Posted - 2010-02-24 : 00:15:37
Can we send array of parameters in stored procedure

and how to use them within sp?

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2010-02-24 : 00:21:37
no.. you need to define each parameter and its data type explicitly...

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-02-24 : 00:36:20
see
http://www.sommarskog.se/arrays-in-sql-2005.html



KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -