I am getting an error on using int datatype on inserting values.
create table Product(
Id_Product nvarchar(10) primary key,
Product_Name nvarchar(30),
Measuring_Unit nvarchar(10),
Unit_Price decimal(3,2),
Quantity int)
insert into Product values ('PROD0001','Red Bull','250g',10.00,5)
The Error Message:
Msg 8115, Level 16, State 8, Line 1
Arithmetic overflow error converting numeric to data type numeric.
The statement has been terminated.