Declare @SQLQuery nvarchar(max) = 'Select * from ...........'SQL Columns of Type Text can hold more that 8000 chars

use the Varchar(Max)

Declare @Str Varchar(max) Variable Declare= Max problem Solve.

Declare @SQLQuery nvarchar(max) = 'Select * from ...........' SQL Columns of Type Text can hold more that 8000 chars

but text is not available in higher version.

Declare @SQLQuery='select * from ...................n' [More than 8000] when store in table it will truncate data. which is sutiable datatype for this?