Search This Blog

Wednesday, May 6, 2009

How To execute a query string above 8000 chars

You can execute a query string above 8000 chars as follows:

Declare @queryString1 varchar(8000)
Declare @Condition1 varchar(8000)
set @queryString1 =' ..any query string ... '
set @condition1=' ...any query condition....'

exec ('select [column]...... from Table_Name ......... '+ @queryString1 + @condition1)