USE tempdb
GO
CREATE TABLE dbo.MotherBoardTransistors
(
    MotherBoardID int NOT NULL
    ,TransitorID int NOT NULL
    ,XL int NOT NULL
    ,YL int NOT NULL
    ,XU int NOT NULL
    ,YU int NOT NULL
)
GO
CREATE TRIGGER MotherBoardTransistorsIU
ON dbo.MotherBoardTransistors
AFTER INSERT, UPDATE
AS

IF EXISTS (
        SELECT *
        FROM dbo.MotherBoardTransistors T
            JOIN inserted I
                ON T.MotherBoardID = I.MotherBoardID
                    AND T.TransitorID <> I.TransitorID
                    AND (
                            I.XL BETWEEN T.XL AND T.XU
                                OR I.XU BETWEEN T.XL AND T.XU
                        )
                    AND (
                            I.YL BETWEEN T.YL AND T.YU
                                OR I.YU BETWEEN T.YL AND T.YU
                        )
    )
BEGIN
   RAISERROR ('Transistor Overlap.', 16, 1)
   ROLLBACK
END
GO

INSERT INTO dbo.MotherBoardTransistors
SELECT 1, 1, 0, 0, 2, 1
GO
INSERT INTO dbo.MotherBoardTransistors
SELECT 1, 2, 5, 0, 8, 2
GO
INSERT INTO dbo.MotherBoardTransistors
SELECT 1, 3, 1, 0, 3, 2 
GO

--DROP TABLE dbo.MotherBoardTransistors