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 - 2007-01-23 : 10:10:30
|
| kulvinder writes "where is identity current value is stored in the SQL databse wether it is in tempdb, master etc.How can we get the current values of the identity columns without using @@Identity" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-23 : 10:26:51
|
| Current identity value is stored in the syscolumns system table.You can also use IDENT_CURRENT() or SCOPE_IDENTITY to get the current values.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
IDENTITY FIELD