Select from following answers:- InitialSize FLOAT(10)
- MaxSize REAL
- TextData NVARCHAR(8000)
- Status CHARACTER
- All Above
Maximum allowed size of NVARCHAR is 4000 .
Msg 2717, Level 16, State 2, Line 1 The size (8000) given to the parameter 'TextData ' exceeds the maximum allowed (4000).
If you want to make use of NVARCHAR for the size > 4000 then you should declare it as NVARCHAR(MAX)
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator