동적쿼리 NVARCHAR(4000) 이상 사용시..

DECLARE @sqlStr1 nvarchar(4000), @sqlStr2 nvarchar(4000), @sqlStr3 nvarchar(4000), @sqlstr nvarchar(max)
SET @sqlStr1 = N'SELECT ''' + REPLICATE(N'1', 3980) + ''' UNION ALL '
SET @sqlStr2 = N'SELECT ''' + REPLICATE(N'2', 3980) + ''' UNION ALL '
SET @sqlStr3 =  N'SELECT ''' + REPLICATE(N'3', 3991) + ''''

SELECT LEN(@sqlStr1) as sqlStr1_Length, LEN(@sqlStr2) as sqlStr2_Length, LEN(@sqlStr3) as sqlStr3_Length

SET @sqlStr = CAST(@sqlStr1 AS nvarchar(max)) + CAST(@sqlStr2 AS nvarchar(max)) + CAST(@sqlStr3 AS
nvarchar(max))

SELECT LEN(@sqlStr) as sqlStr_Length

EXEC sp_executesql @sqlStr