3.2.09

SQL Server Error

Error Message:
Msg 8152, Level 16, State 14, Line 4
String or binary data would be truncated.

Example:
create table venkat(id int, name varchar(10))
insert into venkat
select 1,'Venkat'
union all
select 2,'arun'
union all
select 3,'Lakshmifdsaf'
union all
select 2,'arun'

You are trying to insert the data, which is beyond the allowable size. The data "Lakshmifdsaf" will hold more size when compared to the allowable size.

Happy Learning!!!
Regards,
Venkatesan Prabu .J

No comments:

Post a Comment