Going beyond VarChar(8000)

From

22/03/2010 15:14:56

To

Todo

General information

Fórum:

Microsoft SQL Server

Category:

Título:

Going beyond VarChar(8000)

Environment versions

SQL Server:

SQL Server 2008

Application:

Web

Miscellaneous

ID da thread:

01456238

ID da mensagem:

01456238

Views:

118

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?