CREATE PROCEDURE [dbo].[nameProcedure]
(campos)
AS
BEGIN
	BEGIN TRY
		BEGIN TRANSACTION
        COMMIT TRANSACTION
	END TRY
	BEGIN CATCH
		IF @@TRANCOUNT > 0 BEGIN
			ROLLBACK TRANSACTION
		END
		SELECT CONCAT('Msg Error: ',ERROR_MESSAGE(), '- Procedimiento 
        Afectado:', ERROR_PROCEDURE(), ' - Linea Afectada', ERROR_LINE())
	END CATCH
END