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.

4 comments:

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]

Anonymous said...

күріш суп
күріш суп
lкүріш суп
күріш суп
қадам
жаңа студенттер
Мектеп
жұмыс істеуге өту
жұмыс істеуге өту
жұмыс істеуге өту
Турагенттік
жұмыс істеуге өту
Мектеп
жұмыс істеуге өту
Турагенттік
Турагенттік
Турагенттік
жұмыс істеуге өту
Турагенттік
Мектеп
жұмыс істеуге өту
жұмыс істеуге өту
Турагенттік
жұмыс істеуге өту
жұмыс істеуге өту
Турагенттік
Турагенттік
Мектеп

Tree Ple said...

baby oil
pan
plate
rice ladle
bucket
glass
basin
powder
lotion
spoon
watch
shoe
slippers
tire
egg
hat
cigarette
hangers
veil
strange people
crazy
dish rack
helmets
doll
shampoo
soap
bread
cake
cheese
chicken
bra
shorts
bag
book
scissors
knife
towel
cable
roof tile
flower
balm
light
car
scissors
ashtray
fan
stove
sheath
broom
duster
baby oil
pan
plate
rice ladle
bucket
glass
basin
powder
lotion
spoon
watch
shoe

Pavel Co Ebele said...

Very much useful article. Kindly keep blogging

Java Training in Chennai

Java Online Training India