i am inserting a row into the database with a simple INSERT. One of the columns is auto-identity. How can i select the Identity that i just inserted into the table. MAX won't work b/c there is the possibility of more than one user at a time so MAX may not be accurate. I know of something called @@IDENTITY but i'm not sure of how to use it. Any Suggestions?