ansaurus

Question

Answer 1

+4 A:

There is a property "Identity Specification". Expand that one, you can chose Increment value, and Increment Seed

Ropstah 2009-06-05 21:02:23

This is for SQL Server by the way.

Ropstah 2009-06-05 21:03:19

I'd bet sql server since it is asp.net

KM 2009-06-05 21:04:33

I do .NET with Oracle, see my other answer. I was just assuming SQL Server somehow.....

Ropstah 2009-06-05 21:06:19

I expanded "Identity Specification" and try to edit "Identity increment" but I cannt do that, becuse it's not enlighten

2009-06-05 21:45:13

First change "Is identity specification" to: Yes

Ropstah 2009-06-05 22:03:43

thanks, but see this pic: http://www.rofof.com/img2/6xsbuy6.gif

2009-06-06 13:25:00

doubleclick NO, then it will turn into YES

Ropstah 2009-06-06 15:58:02

Answer 2

A:

In Sql Server define the column like this...

[PrimaryID] [int] IDENTITY(1,1) NOT NULL

Then you can add a constraint making it the primary key.

Craig 2009-06-05 21:03:04

Answer 3

+2 A:

MySQL: http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
Oracle http://webxadmin.free.fr/article/oracle-autoincrement-columns-134.php
SQL Server: http://forums.devx.com/showthread.php?t=151539

Robert Greiner 2009-06-05 21:04:11

Answer 4

A:

For Oracle it is a bit more trivial. You first have to create a sequence and then a trigger.

Ropstah 2009-06-05 21:05:31

did you mean to say "non-trivial"?

Ape-inago 2009-06-05 21:30:29

Answer 5

+1 A:

Since you listed ASP.NET, I'm going to assume you are running a SQL Server 2005/2008. If you want to use the GUI, then follow these steps:

Josh 2009-06-05 21:06:48

Answer 6

A:

Thanks all, I use SQL Server 2005 which coming with VB.NET 2008

can you help me ?

I want a solution without writing in a code, I mean using GUI of vb.net 2008

2009-06-05 21:28:02

for future reference, standard stackoverflow policy is to edit your question for clarification instead of posting an answer.

Jimmy 2009-06-05 21:33:22

How can I make a primary key as AUTOINCREMENT