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)
 Parameter field of a stored procedure-with mutiple values

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-04 : 11:16:24
samsql writes "I have a stored procedure which retrives data depending upon three parameter fields. one parameter field is Mandatory and other two are optional. When I run the stored procedure with optional parameters keeping Null,it works fine. But third parameter field can accept mutiple values. That variable can accept like 1,2,3,4,5 and the stored procedure should tretive data related to that parameter fields.

Optional parameters act like filtering criteria."
   

- Advertisement -