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)
 Unlimited Number of Input Parameter in SP?

Author  Topic 

khufiamalik
Posting Yak Master

120 Posts

Posted - 2008-09-05 : 02:30:27
Is there any way by which I can pass Unlimited variables in my SP???

Actually I have to write a SP and Number of inputs are undefined.

Can any one help me that how to do this.

Thanks in advance.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-09-05 : 02:32:38
You can define 2100 parameters to a SP.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

sunil
Constraint Violating Yak Guru

282 Posts

Posted - 2008-09-05 : 02:34:56
http://msdn.microsoft.com/en-us/library/ms191132(SQL.90).aspx
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-09-05 : 03:28:20
Are you trying to do something like this?
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -