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?