>I have a script which executes a line and I define the variable to hold the line command like this:
>
>

>DECLARE @SQL varchar(8000)
>

>
>However, in one generation, the line is 11897 characters long. Am I allowed to use another type of declaration to go beyond the 8000 character limit?


varchar(max) ?