forum

home / developersection / forums / error while insert value in table.

Ask Question

Error while insert value in table.

Anonymous User 2600 15-Dec-2012
 when i insert any value in table when a error generated 
my table:
create table customer
(
id int primary key,
f_name varchar,
l_name varchar,
age int
)

insert Query:
insert into customer values(1,'John','Rob',22)

Error:

Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.
 help me anybody.



mssql server mssql server 
Updated on 09-Apr-2013
Anonymous User

Other

I am a content writter !

Message
Can you answer this question?
Answer

2 Answers

Shankar M

Shankar M

09-Apr-2013
Hi John,

The Error Message says that the values that you are trying to insert to the column specified has exceeded the column length. Alter your table structure and try working it.

Thanks,
Shankar
Vijay Shukla

Vijay Shukla

15-Dec-2012
You can just alter your table with this below code:
create table customer
(
id int primary key,
f_name varchar(50),
l_name varchar(50),
age int
)
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy