How to get the primary key right after insertion

<i><b>Originally posted by : Carol (cxi@frymulti.com)</b></i><br />This is always a question to me, hope somebody can give me help. <br /><br />If you have a table with an identity as the primary key, how to get the number out after you insert a row into the table. (under multiple users' situation). <br /><br />Thanks! <br />

<i><b>Originally posted by : Carol</b></i><br />I got the answers. For those who are interested, please go to the following link:<br />http://www.aspfree.com/authors/briang/identitywithsql.asp<br /><br /><br />------------<br />Carol at 6/15/2000 9:01:09 AM<br /><br />This is always a question to me, hope somebody can give me help. <br /><br />If you have a table with an identity as the primary key, how to get the number out after you insert a row into the table. (under multiple users' situation). <br /><br />Thanks! <br />

<i><b>Originally posted by : Axon (axon_omni@yahoo.com)</b></i><br />what is the varible that contains the ID?<br /><br /><br />------------<br />Carol at 6/19/2000 2:54:26 PM<br /><br />I got the answers. For those who are interested, please go to the following link:<br />http://www.aspfree.com/authors/briang/identitywithsql.asp<br /><br /><br />------------<br />Carol at 6/15/2000 9:01:09 AM<br /><br />This is always a question to me, hope somebody can give me help. <br /><br />If you have a table with an identity as the primary key, how to get the number out after you insert a row into the table. (under multiple users' situation). <br /><br />Thanks! <br />