Passing Multiple Values to a Single Parameter? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Passing Multiple Values to a Single Parameter?

Message

De

21/09/2004 20:49:43

Martin Metharam
Manila, Philippines

À

21/09/2004 20:44:26

Sergey Berezniker
New York, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Stored procedures, Triggers, UDFs

Titre:

Re: Passing Multiple Values to a Single Parameter?

Divers

Thread ID:

00943913

Message ID:

00944814

Vues:

24

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