Correct syntax is
INSERT INTO RESERVATION (R_RESERVATIONNUM, T_TRIPNUM, R_TRIPDATE, R_NUMPERSONS, R_TRIPPRICE, R_OTHERFEES, C_CUSTOMERNUM) VALUES ( ... );
You have to indicate which columns, and in which order, for the
INSERT
statement to be clear about what goes where.
Moreover, the precision you have chosen for your decimal columns seems a little bit too low (only 3 digits, left and right from the decimal point). With the values you provided, precision should be at least 4, but you could go to 9 without impacting the number of bytes used to store the values.
Please see
decimal and numeric (Transact-SQL) | Microsoft Docs[
^] for further information.