Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting a next number value
Message
 
To
11/10/2007 06:33:02
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01259689
Message ID:
01260215
Views:
12
>Hello Borislav!
>In help Transact-SQL :
>
>@@IDENTITY, SCOPE_IDENTITY, and IDENT_CURRENT are similar functions because they all return the last value inserted into the IDENTITY column of a table.
>I have chosen first.
>Now I try to use SCOPE_IDENTITY() function.
>
>Thank you for answer.
>
Read the paragraph bellow that you quoted:

@@IDENTITY and SCOPE_IDENTITY return the last identity value generated in any table in the current session. However, SCOPE_IDENTITY returns the value only within the current scope; @@IDENTITY is not limited to a specific scope.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform