To Store More then 8000 in Varchar for dynamic Query

Question

I Need to store more then 8000 charcters in varchar variable to execture dynamica query pls help

Nilesh Shah · Answer

You can use varchar(MAX) which has limit upto 2 GB storage which is quite enough for any dynamic query

Nilesh Shah · Answer

It not working as problem cames again Saravana - what is the problem? what is not working? post your code and error

Manish Kumar · Answer

Use nvarchar(max) for dynamic query.

Nitin Sontakke · Answer

Unless you mention the error how can we help you? Please share error details.

Hariharan Krishnamoorthi · Answer

Hi Saravana kumar explain the exact error you face. Try to use NVARCHAR(MAX) datatype. This will really help to handle dynamic queries.

S.Saravana Kumar · Answer

It not working as problem cames again