<div>
Okay, I'll bite. &nbsp;How did my comment not correctly answer the question?
</div>


Okay, I'll bite.  How did my comment not correctly answer the question?

<div>
Jim,<br />
<br />
Your answer was correct. Since there were 2 correct answers, I accepted multiple answers.
</div>


Jim,

Your answer was correct. Since there were 2 correct answers, I accepted multiple answers.

<div>
I'm showing that only the second answer was accepted, so if your intent was to split you'll need to re-open the question and re-award points.
</div>


I'm showing that only the second answer was accepted, so if your intent was to split you'll need to re-open the question and re-award points.

<div>
Thanks for the split. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the split.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
I need to write a Stored Procedure that will Insert a record into a Table and then return the Primary Key and I'm not sure how to do that. I'm using SQL Server 2008.
</div>
</div>


I need to write a Stored Procedure that will Insert a record into a Table and then return the Primary Key and I'm not sure how to do that. I'm using SQL Server 2008.

Need to perform a DB Insert then return an ID?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.