How can I insert a Record to Database and get the ID in Same Query

Published by: Matt (8/16/2008)

I was trying to insert a record and fetch the id in same query, i don't know the best way but i don't want to make this in 2 querries. Can you guys help me in getting the result?

 

Most Popular Articles

• How can I run my Stored Procedure in SQL Server 2005
• SQL Join Query for Microsoft Access Database
• What is the use of nolock condition in SQL Query
• How can I Truncate my Database Log to Reduce the Size
• when to use cast and when to use convert operator in SQL

To Update Should I Delete before Insert >>

<< How do I Design a Database Which can Easily Handle the 10 Levels of Categories