Sql server 2008 constraint for exec statement

Question

I just needed to double check if the character limit exists in the EXEC command in t-sql? If I have a variable with varchar (max) and execute the command using EXEC, do you think this is normal?

thank

Answer 1

It should be fine, according to this MSDN article.

Relevant Part:

Using EXECUTE with a character string

SQL Server 8000 . . SQL Server varchar (max) nvarchar (max), 2 .