Pass an Array as a parameter to a SP? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Pass an Array as a parameter to a SP?

Message

De

29/03/2002 08:23:05

Wesley Holden
Paul Consulting
Tallahassee, Floride, États-Unis

À

28/03/2002 15:31:38

Michael Levy
Cincinnati, Ohio, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Stored procedures, Triggers, UDFs

Titre:

Re: Pass an Array as a parameter to a SP?

Divers

Thread ID:

00638389

Message ID:

00638873

Vues:

26

I am using SQL Server 2000...

Will there be any performance gain by using XML versus passing the SP 28 parameters(each parameter is a small char value) ?
If so, where can I go to get a jump start on converting the array to XML; I have not used any XML for my Apps.

My ASP Application will have 2,000 users (most all of them using the app at the same time).

TIA

>> Wes

Click here to load this message in the networking platform