sql server query to insert dateofbirth and emailid ?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

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

Posted 28-Aug-15 21:11pm

Xaavier

Add a Solution

Comments

Xaavier 29-Aug-15 5:44am

how can i store date of birth in sql server
and what is query for creating the date of birth

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2015-08-28T21:33:00

When you do an INSERT query, it's a very good idea to always list the columns you are going to insert the data into, or SQL will just start with the current first column and insert your values starting with that.
In your case, that first column is an IDENTITY column - so even if you did supply an integer value, it still would throw an exception.
Try:

SQL

INSERT INTO mst_reg (Name, Lastname, Fathername, Qualifiaction, Emailid, Phno) VALUES ('aqib', 'javid', 'nijamudeen', 'BTechIT', 'aqib55@live.com', 965557017796)

But please, if you are doing this via a high level language, remember to use parameterized queries! Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead

Michael_Davies · Accepted Answer · 2015-08-28T21:51:00

Solution 2

You are also storing the phno field as an integer, there is a limit on the size of number stored in numeric fields, store it as text.

Posted 28-Aug-15 21:51pm

Michael_Davies

Comments

Xaavier 29-Aug-15 5:44am

how can i store date of birth in sql server
and what is query for creating the date of birth

Ravindranath_Kanojiya · Accepted Answer · 2015-08-28T22:46:00

Solution 3

Hi,
You can have your Phone no up to 10 digit, As Error itself suggest that Arithmetic overflow.
It means int have some limit. you can change that datatype to bigint

create table mst_reg
(

id bigint not null identity(1,1),
Name varchar(80),
Lastname varchar(80),
Fathername varchar(80),
Qualifiaction varchar(80),
Emailid varchar(80),
DOB DATETIME NOT NULL,
Phno bigint

)

Posted 28-Aug-15 22:46pm

Ravindranath_Kanojiya

Updated 30-Aug-15 5:44am

v4

Comments

Xaavier 29-Aug-15 5:44am

how can i store date of birth in sql server
and what is query for creating the date of birth

Ravindranath_Kanojiya 30-Aug-15 11:38am

You can have a Column in you table and Datatype as DateTime
ALTER TABLE YourTableName ADD DOB DATETIME NOT NULL

sql server query to insert dateofbirth and emailid ?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us