How to execute dynamic query having length > 8000 bytes

Question

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!!!