July 17, 2011 at 10:15 pm
in employee table...where i want to convert ename which is in nvarchar and later i want to convert it into varchar
I got following error
Msg 8152, Level 16, State 2, Line 1
String or binary data would be truncated.
The statement has been terminated.
Sagar Sonawane
** Every DBA has his day!!:cool:
July 17, 2011 at 11:08 pm
did you try to convert it to varchar(max)?
July 17, 2011 at 11:11 pm
No...
Sagar Sonawane
** Every DBA has his day!!:cool:
July 17, 2011 at 11:15 pm
if width of nvarchar column is nvarchar(max) then please try to convert it to varchar(max).
July 18, 2011 at 12:11 am
Hi buddy,
This error comes because there is problem with your data length.
Whenever you convert data type, please check your max(Len).
Regards,
prashavhad
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply