Why am I getting this error message when I go to execute my query?

Question

User1938579050 posted

Does anyone know why I'm getting this error message when I go to execute my query?

Answer 1

User475983607 posted

You've configured the BookingID column as a primary key and Identity column.  Just remove the first '1' from the insert.  However, there are other issues with the INSERT and design.  Date data is not a proper date format, time slot should be two columns; start and end, Price should be currency.  

I recommend learning proper database table design; normalization. 

https://support.microsoft.com/en-us/help/283878/description-of-the-database-normalization-basics

https://docs.microsoft.com/en-us/sql/lp/sql-server/database-design?view=sql-server-ver15#pivot=products&panel=products1

Answer 2

User-719153870 posted

Hi Joe_p123,

Seems you are inserting values to identity field [Booking ID].

An identity filed means it will grow automatically based on its seed and increment, its value can not be set unless you SET Identity_insert.

In my opinion, you can just ignore its value:

insert into dbo.booking values('1','1','19 12 20','07:00 - 17:00','Morning f12+2')

For more information about insert in SQL Server: The SQL INSERT INTO Statement.

In addition, please mark the post which helped solve your problem as the answer so that it could help more people who met the same problem.

Best Regard,

Yang Shen