Stored Procedure with Try Catch in SQL
-- ============================================= -- Author: <SARAVANANS> -- Create date: <22-NOV-14> -- Description: <Common sp to update employee details> -- [usp_update_employee] 1 -- ============================================= CREATE PROCEDURE [dbo].[usp_update_employee] @EmployeeID INT , @EmployeeSalary MONEY AS BEGIN TRY SET ARITHABORT ON SET NOCOUNT ON UPDATE EMPLOYEE SET EMPLOYEESALARY =@EmployeeSalary WHERE EmployeeID =@EmployeeID END TRY BEGIN CATCH SELECT @ErrorNumbe...