SQL Server Data Types for Local Variables

[DBA]

Is there ANY data type other than varchar that is valid for local
variables and allows more than 8000 characters?

[Simon Hayes]

"DBA" <ka******@yahoo.com> wrote in message
news:ff*************************@posting.google.co m...

Is there ANY data type other than varchar that is valid for local
variables and allows more than 8000 characters?

No - if you can give more details about what you need to do, someone may be
able to suggest a solution.

Simon

[Erland Sommarskog]

DBA (ka******@yahoo.com) writes:

Is there ANY data type other than varchar that is valid for local
variables and allows more than 8000 characters?

In SQL2000, no. In the upcoming version of SQL Server, SQL 2005 currently
in beta, the situation is radically different.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Christina Starr]

Thanks for the confirmation! I have a TSQL script that will read from a
table, concat. the results into a string (8000 characters), and then use
the extended stored procedure, xp_smtp_sendmail, to send the
concatenated string (variable) as a message. Unfortunately, I found that
xp_smtp_sendmail also has a limitation of 8000 characters for the
message ( probably just b/c of SQL Server's own varchar size
limitation). I appreciate the help! I will look forward to SQL 2005.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!