devxlogo

adding records but not using primary key

adding records but not using primary key

Question:
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?

Answer:
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.

devx-admin

Share the Post: