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
http://www.insidesql.de
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 —————————————-
http://spaces.msn.com/members/dineshasanka

---

]]>