I have attached a copy of a stored procedure which I am
using. This stored procedure contains a Begin Tran and a
Commit Tran. However, when we call this stored procedure
and the connection is unexpectedly terminated all data
being added is rolledback. Yet, The EmployeeScheduleId,
PK is being returned to the application as if the add was
successfully. When we search the database this Id does
not exist and SQL server has skipped this Id.
Would putting this statement "SELECT IDENTITY as
EmployeeScheduleId" ensure that only the Id is returned if
the data is committed or is their a ...