Is there any other way apart from using the INSERT INTO command that allows you to append a line to a database? I have a primary key “ID,” but can I add a record without having to know what the next available unused ID is?
For SQL Server to insert a value automatically for your primary key, you need to use the identity property in your table declaration. For example:
create table orders( orderid int identity(1,1), ...)
When inserting, do not explicitly provide a value for the orderid field. SQL Server will provide the next available value for it.