RE: Retrieving Last Inserted IDENTITY value

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Joe, I have written an article for Centerfield's April 2006 newsletter
exploring 5 different SQL AutoIncrement techniques, one of them being
Identity fields:

http://www.centerfieldtechnology.com/publications/

HTH, and don't critique too harshly please :)

Elvis

-----Original Message-----
Subject: Re: Retrieving Last Inserted IDENTITY value

Hope this is not too basic, but it would definitely help me and others 
here...

I have only used Identity fields for a couple of tools on the iSeries, but I

used the AutoIncrement field a LOT when developing apps for Access.  On the 
iSeries apps I always wound up using the Max() technique to get the last 
inserted.

That said, I am obviously interested in how IDENTITY_VAL_LOCAL is actually 
used.  Can you post a small example?

Many Thanks!
Joe