Passing Multiple Values to a Single Parameter? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Passing Multiple Values to a Single Parameter?

Message

From

21/09/2004 20:49:43

Martin Metharam
Manila, Philippines

To

21/09/2004 20:44:26

Sergey Berezniker
New York, United States

General information

Forum:

Microsoft SQL Server

Category:

Stored procedures, Triggers, UDFs

Title:

Re: Passing Multiple Values to a Single Parameter?

Miscellaneous

Thread ID:

00943913

Message ID:

00944814

Views:

23

If I were using the SQL Query Analyzer of SQL to test the SP. What would be the RIGHT syntax for calling the SP I created. I've tried...

exec MySP1 'A','B','C'

... and ...

exec MySP1 '''A'',''B'',''C'''

... and I either get an error or an empty recordset. Any ideas?

Shit happens!!!

Click here to load this message in the networking platform