How to write a SQL Server Insert Stored Procedure and get back the Identity Column Value.

In this video, I will show you how to write a stored procedure for a table that has an identity column. I will show how commit and rollback affects the value.

I will show you how to write the Stored Procedure.
I will show you how to UNIT Test this Procedure.

-- by : software nuggets
-- is a : sql server nugget
@softwareNuggets, #softwareNuggets, #sqlServer, #insertProcedure,#identityColumn