adding records but not using primary key

adding records but not using primary key

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.


Share the Post: