How and where can I add TRY and CATCH, TRANSACTION in this sql code?

--1ST CODE

CREATE OR ALTER PROCEDURE CST4714.usp_InsertPersonInfo(@SSN CHAR(9), @FN VARCHAR(50), @LN VARCHAR(70) = NULL)  AS  BEGIN      IF @SSN IS NOT NULL AND @FN IS NOT NULL AND @LN IS NOT NULL      BEGIN          INSERT    CST4714.Person(SSN, FirstName, LastName)          VALUES(@SSN,@FN, @LN)      END      ELSE      BEGIN          PRINT 'all attributes are required :)'      END  END  

--2ND CODE

CREATE    PROCEDURE CST4714.usp_InsertPersonEmail(@PID INT, @Email VARCHAR(70), @EmailTypeID INT = 2)  AS  BEGIN      INSERT CST4714.PersonEmail(PID,EmailTypeID,Email)      VALUES(@PID,@EmailTypeID,@Email)    END  

--3RD CODE

CREATE OR ALTER PROCEDURE CST4714.usp_InsertPersonInformation(@SSN CHAR(9), @FN VARCHAR(50), @LN VARCHAR(70),@Email VARCHAR(70) = NULL, @EmailType VARCHAR(30) = 'Personal')  AS  BEGIN      DECLARE    @PID INT              ,@EmailTYPEID INT              ,@PID2 INT        INSERT    CST4714.Person(SSN, FirstName, LastName)      VALUES(@SSN,@FN, @LN)        SET @PID = @@IDENTITY      --SET @PID2 = SCOPE_IDENTITY()        SELECT @EmailTYPEID = EmailTypeID      FROM CST4714.EmailType WHERE EmailType = @EmailType            IF @Email IS NOT NULL AND @EmailType IS NOT NULL      BEGIN          EXECUTE  CST4714.usp_InsertPersonEmail @PID = @PID                                  ,@Email = @Email                                  ,@EmailTypeID = @EmailTYPEID      END  END  

https://stackoverflow.com/questions/67259647/how-and-where-can-i-add-try-and-catch-transaction-in-this-sql-code April 26, 2021 at 09:00AM