sql server query to insert dateofbirth and emailid ?
create table mst_reg 
(id int not null identity(1,1),
Name varchar(80),
Lastname varchar(80),
Fathername varchar(80),
Qualifiaction varchar(80),
Emailid varchar(80),
Phno int
)


insert into mst_reg values('aqib','javid','nijamudeen','BTechIT','aqib55@live.com',965557017796)


while executing the query to insert the data ito the table it shows 
"
Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
The statement has been terminated." please help me
August 29th, 2015 3:30am

insert into mst_reg values('aqib','javid','nijamudeen','BTechIT','aqib55@live.com',655456886)

will work..check int length then insert.

Free Windows Admin Tool Kit Click here and download it now
August 29th, 2015 1:47pm

An integer data type can store values between -2,147,483,648 and 2,147,483,647 (https://msdn.microsoft.com/en-us/library/ms187745.aspx).  The Phno value exceeds this range.  If this is a telephone number, I suggest you use varchar instead.

August 29th, 2015 1:53pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics