I am applying some SQL tests to my database and i've encountered an error.
When i try to run this syntax;
INSERT INTO Artikel (Artnamn, Antal, Pris, Rabatt) VALUES ('Bildskärm-platt 10ms', '45', '2175,00', '0,00'), ('Tangentbord', '37', '280,00', '0,00'), ('Nätkabel TP kat 5', '1000', '2,50', '0,00')
I get an errormessage telling me the following:
Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.
The table is formed such that:
Artnamn(Product) = Varchar(30)
Antal(Amount) = (int)
Pris(Price) = (decimal 6,2)
Rabatt(Discount) = (decimal 2,2)
I am still a beginner at this i've been and i am only at my 3rd week into this course.
Would appreciated any tips or hints very much, i don't understand why it want to convert my string in the first place.
I just wanna enter the product name :S
This post has been edited by heady89: 18 April 2010 - 09:37 AM