Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?

Links

XODOX
Impressum

#1: FAQ & Solution: How to generate a number automatically for the

Posted on 2008-04-22 14:51:23 by DanielLauJJ

When inserting a record into a table, I want SQL Server to generate a
number automatically for the Primary Key. (e.g. OrderID is 1, 2, 3
and so on) How to do it?
(This behavior is similar to the "Auto-number" in Microsoft Access)

http://raymondlamsk.blogspot.com/2008/03/faq-ms-sql-server-h ow-to-generate_24.html

Report this message

#2: Re: FAQ & Solution: How to generate a number automatically for the

Posted on 2008-04-23 09:29:15 by ivce970

On Apr 22, 5:51 am, "DanielLa...@gmail.com" <DanielLa...@gmail.com>
wrote:
> When inserting a record into a table, I want SQL Server to generate a
> number automatically for the Primary Key. (e.g. OrderID is 1, 2, 3
> and so on) How to do it?
> (This behavior is similar to the "Auto-number" in Microsoft Access)
>
> http://raymondlamsk.blogspot.com/2008/03/faq-ms-sql-server-h ow-to-gen...

Hi Daniel.

I'll try to answer your question and hope it will work out.

All you have to do is to look under properties of your Primary Key
column. Below, just before the end of properties is property Identity.
You should change that property to be Yes instead of No, and click OK
to conform this change.

Sincerely yours,

Ivan Delic, Serbia

Report this message