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?


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 :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.