varchar(MAX) text cuts off while going more than 8000 characters inside a procedure
8
votes
2
answers
16121
views
I have a procedure in which i have declared a variable with datatype varchar(MAX),
declare @str varchar(MAX);
set @str='select * from Table1...'
print (@str);
exec (@str);
but when the text written inside @str goes above 8000 characters (i.e. 8193 characters) it cuts off the string and prints only 8000 characters and executing it gives error off course.
I have tried 2 solutions after some search, but it doesn't work.
1) I have tried using 2 variables of same type "varchar(MAX)", and concat it at the time of execution, but doesn't works.
2) I have tried to cast "into varchar(MAX) again" both the variables before concatinating it, and then execute it, but that also doesn't works.
Asked by Priyank Pahuja
(83 rep)
Aug 25, 2017, 06:29 PM
Last activity: Aug 15, 2024, 05:59 AM
Last activity: Aug 15, 2024, 05:59 AM