To Store More then 8000 in Varchar for dynamic Query

"It not working as problem cames again"

Saravana - what is the problem? what is not working? post your code and error

Use nvarchar(max) for dynamic query.

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

Hi Saravana kumar, explain the exact error you face.

Try to use NVARCHAR(MAX) datatype. This will really help to handle dynamic queries.

It not working as problem cames again

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