Well, I'm new here but you can halp me also.
I have pretty big problem. I need to store large text (more than 8000 charaters) in variable inside of procedure and then execute that query with EXEC command. Problem is that varchar supports up to 8000 characters and text and ntext cannot be declared inside procedure.
Is there any way to do this? BLOB? User defined types in MSSQL? Something?
Thx
Jump to Postyou should be able to use a nvarchar(max)
you should be able to use a nvarchar(max)
nvarchar(max) won't help. from what i have found so far there is possability that varchar uses more than 8000 characters.
thx anyway.
p.s. question still stands so you can reply :)
you could also use varchar(max)
here's a link that will explain it
http://www.teratrax.com/articles/varchar_max.html
and also a reference for it (check out #2)
http://www.sql-server-helper.com/faq/sql-server-2005-varchar-max-p01.aspx
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.