Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Sep 18, 1998

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 Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date