Obtained auto number in SQL server

CodeCharge Studio

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

Obtained auto number in SQL server

Author

Message

jocelyn

Posted: 10/11/2002, 12:14 AM

I know how to obtain it in Access but I just can figure it out in SQL server 2000

Any help

jocelyn

Posted: 10/11/2002, 1:00 AM

Ok I found it, sorry to ask such basic question

In you SQL server Enterprise manager select your database/table, select the primary key and set the property identity to YES.

Best regards

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login