how to use text data type as output parameter in stored procedures using sql server 2000

mention "OUTPUT" after declaring variable
ex:
f1 varchar(20) OUTPUT

Always:),
Hovik Melkomian.

Do you mean the TEXT datatype?

If so, then a lot depends on your client software. Using ADO, for example, the TEXT datatype is mapped to the ADO parameter type 'advarchar'. Since the TEXT datatype can be very long, an OUTPUT parameter may not be the best way to handle this - instead you may consider handling the data in chunks of a more manageable size. In this case, return the TEXT datatype in a query resultset and use, for example, the GetChunck method of the ADO field object.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com