AFTER INSERT
AS
BEGIN
    SET NOCOUNT ON;
    IF ((SELECT EmployeeID FROM inserted) NOT IN (SELECT EmployeeID FROM Employee AS emp
                                                JOIN Position AS ps ON ps.PositionID = emp.PositionID WHERE PositionName = 'Seller'))
    BEGIN
        ROLLBACK;
        THROW 51000, 'Incorrent EmployeeID.', 1
    END
    ELSE
    BEGIN
        --BEGIN TRY
            UPDATE Phone
            SET Sold = 1
            WHERE SerialNumber = (SELECT SerialNumber FROM inserted)
        --END TRY
        --BEGIN CATCH
        --  ROLLBACK;
        --  THROW 51002, 'Update Error', 0
        --END CATCH
    END
END