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 |
|
jept
Starting Member
14 Posts |
 Posted - 2007-09-07 : 13:16:23
|
| I have a table with an automatic count int. What I want to know is there an sql statement to return the next increment from the sequence. Any help would be appreciated. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-07 : 13:18:58
|
| scope_identity()_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
getting the next increment
SELECT SCOPE_IDENTITY()+1 AS Next_ID_In_ScopeBrett8-)Hint: Want your questions answered fast? Follow the direction in this link