How do I get the IDENTITY / AUTONUMBER value for the row I inserted?

Created: 7/9/2000 5:49:40 PM
Last Modified: 3/12/2005 3:12:46 PM 
Visits in the last 7 days: 1579
Visits in the last 24 hours: 161