Liladhar Nimje

Liladhar Nimje

  • 2k
  • 30
  • 3.7k

How to execute dynamic query having length > 8000 bytes

May 6 2016 8:01 AM
Hi,
 
I am executing a query using "Exec (@Query)" syntax, where @Query is having length greater than 8000 bytes in size. So when I am trying to execute this query, it is not going to execute whole query and giving error.
 
I have a Eg for that,
 
Declare
      @a  Varchar(8000),
      @b Varchar(8000);
 
Select 
      @a = ' ', -- @a contains insert query
      @b = ' '; -- @b contains where clause
 
Execute (@a + @b)
 
 Thanks for your help in advance!!!
         

Answers (3)