insert into SignUpForm
values ('Torito', 9984537856, 'toritom@gmail.com', 'Torito@123')
I am trying to run the above query but it will throw this error:
Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
Please give me the appropriate solution for this.
I created the table with the following datatypes.
name varchar(50)
mobile bigint
mail varchar(50)
password varchar(50)
insert into SignUpForm
values ('Torito', 9984537856, 'toritom@gmail.com', 'Torito@123')
1条答案
按热度按时间k97glaaz1#
looks like the order of column value not matching with column order present in table.
the values needs to be in order of columns present in your table. e.g.
try with this, if error persist then need to investigate further..