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)
 Stored Procedure Parameters

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-11 : 16:35:42
Gert writes "Hi

Is it possible to send an array of values, or multiple values to a SQL 6.5 stored procedure?

What I want to do is have a stored proc to which I can send multiple values for the same param to then perform an "IN (value1, value2......., valuen) type query.

So, if I can set a parameter to an array and then traverse the array contents in the stored procedure, that would be nice....

Thanx

Gert"
   

- Advertisement -