SQL Server Performance Forum – Threads Archive
varcar
How to assign a variable which will accept more than 8,000 characters(I need unlimited) with varcar function. It should take exact space though the option is unlimited like varcar. Thanksjohn
You’re out of luck. 8,000 is the max for varchar.
Would it help to split into two or more varchar variables? Frank
http://www.insidesql.de
http://www.familienzirkus.de
If not consider TEXT datatype or TABLE datatype to work as a variable in the database.
REfer to books online for more information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>