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.
Monday, June 18, 2007
IDENT_CURRENT,SCOPE_IDENTITY and @@IDENTITY
Subscribe to:
Post Comments (Atom)
1 comment:
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]
Post a Comment