Google Search

Google
 

Monday, June 18, 2007

IDENT_CURRENT,SCOPE_IDENTITY and @@IDENTITY

SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY are similar functions in that they return values inserted into IDENTITY columns.



IDENT_CURRENT is not limited by scope and session; it is limited to a specified table. IDENT_CURRENT returns the value generated for a specific table in any session and any scope.



SCOPE_IDENTITY and @@IDENTITY will return last identity values generated in any table in the current session.



However, SCOPE_IDENTITY returns values inserted only within the current scope; @@IDENTITY is not limited to a specific scope.

1 comment:

Anonymous said...

I want to get the new unlimited plan from cricket for $49.99 I've heard they have a cdma network enabled iphone available or that you can flash the iphone from gsm to cdma that cricket use's. Also i've heard you can get a universal sim card and flash it to work with cricket.
[url=http://wonderland.fws.cc/index.php?topic=161.new#new]unlock iphone[/url]