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?