exceeding limit(varchar) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

exceeding limit(varchar)

one Job in sql server 2000 i declared a variable as a varchar.
but its maximum limit is 8000 how can i take morethan limit i.e. 8000
You might be able to use 2 or more VARCHAR(8000) variables and do EXEC @[email protected]
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?http://www.insidesql.de/blogs

A stored procedure can take a TEXT parameter – if that’s any help. It’s the only way you can use the TEXT data type outside of a table definition (that I know of).
For information
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52274 —————————————-