12-17-2018 2:55 AM
maxlength1.jpgmaxlength2.jpgHi Experts,
I have an NVARCHAR variable in SQL Script of length 5000. This variable stores a dynamic SQL query of variable lengths. However, in the debugger when I right click on this variable and inspects its value, it always truncates the value. It shows only upto 1027 charectors. I have right clikced on the value pane and set the max length to 10000 already. However this does not help. Any suggestions please?
Thanks,
Ajith