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 |
|
Lin100
Yak Posting Veteran
70 Posts |
 Posted - 2006-09-17 : 13:07:49
|
| What is the SQL code to mimic an AutoNumber field like in Access.Access 2002 and SQL 2000 Server.I have an Access database (MDB) that have linked tables that resided in SQL.In Access, there is a field of a type AutoNumber, but not in SQL.What is SQL code for a trigger for a field named "RecordID" so that everytime a newrecord is added, it gives an increment number to RecordID.Right Click --> All Tasks --> Manage Triggers |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-17 : 13:44:54
|
| Have a look at identity in bol==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
What is the SQL code to mimic an AutoNumber field