autoincrement column in SQL database

Question

I have two value in one table in database which I need to autoincrement. First value is ID it's a primary kay and it is setup as Identity Column and have (Is Identity) - Yes in properties. And how setup my second value (number) to autoincrement. When I setup his property (Is Identity) yes it automaticly change Identity Column for number.

Is possible to meke autoincrement for two value in one table in sql?

Are you talking about MySQL or SQL Server? Auto increment is mysql, where Identity is SQL Server.. — Michiel van Vaardegem
– Michiel van Vaardegem, Commented Jan 3, 2012 at 19:28

Joe Stefanelli · Accepted Answer · 2012-01-03 19:28:01Z

3

It is not possible to have more than one identity column in a table (and I can't think of a valid reason for wanting to do so anyhow).

answered Jan 3, 2012 at 19:28

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

autoincrement column in SQL database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related