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 2000 Forums
 SQL Server Development (2000)
 Variable number of input parameters...

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-06 : 09:52:54
Dan writes "I need to pass a vvariable number of parameters into a stored proc. I normally would handle this in a static procedure like the following:

SELECT * FROM TableName
WHERE IntegerField IN (1,2,3)

Is it possible to pass in the '1,2,3', or '1,2,3,4,5,6' etc. to a stored proc?"

   

- Advertisement -