Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-07 : 09:13:15
|
Kat writes "Hi
I have a migrated Access database which contains an autonumber field. I'd like to replicate the same autonumber behaviour in the SQL table now using the identity column.
How do I set this ID field to be the identity column? Is it possible to get SQL to start the increment following on from the already inserted ID values? If so, what identity settings do I need to give my ID field?
Regards
Kat
Ps. I'm using NT4, SQL 7.0 and ASP
" |
|
|
|
|
|
Can an already populated int field be set as identity?