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

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Pass an Array as a parameter to a SP?

Message

From

29/03/2002 08:23:05

Wesley Holden
Paul Consulting
Tallahassee, Florida, United States

To

28/03/2002 15:31:38

Michael Levy
Cincinnati, Ohio, United States

General information

Forum:

Microsoft SQL Server

Category:

Stored procedures, Triggers, UDFs

Title:

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

Miscellaneous

Thread ID:

00638389

Message ID:

00638873

Views:

24

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