SQL Transaction

Hi,

I would like to add a commit and rollback transaction to the code below.
Everything I have tried to so far does not seem to work, I think it is because I have multiple action in the code.

Would be grateful for any help.

Thanks

BEGIN
      -- SET NOCOUNT ON added to prevent extra result sets from
      -- interfering with SELECT statements.
      SET NOCOUNT ON;
   
            
                  Insert Into tbl_M04_CompanyRolesHistory
                        (CompanyRoleName, CompanyRoleDescription,
                        CompanyId, LastModifiedBy, HistoryAction, CompanyRoleId)
                        SELECT CompanyRoleName, CompanyRoleDescription,CompanyID, @ModifiedBy, 'Deleted_text', @CompanyRoleID
                        FROM tbl_M04_CompanyRoles
                        Where CompanyRoleID = @CompanyRoleID
                              
                  DELETE dbo.tbl_M04_CompanyRoles
                  Where CompanyRoleID = @CompanyRoleID
                  
                  DELETE tlnk_M04_CompanyRolePermissions
                  WHERE CompanyRoleID = @CompanyRoleID
                  
                  DELETE tlnk_M04_CompanyRoleUsers
                  WHERE CompanyRoleID = @CompanyRoleID
                  
                  SET @ReturnValue = '1'
            
END