带有外键约束的错误失败

-- 示例：插入前检查
IF EXISTS (SELECT 1 FROM Customers WHERE CustomerID = @CustomerID)
BEGIN
    INSERT INTO Orders (CustomerID, OrderDate) VALUES (@CustomerID, GETDATE());
END
ELSE
BEGIN
    PRINT 'Customer does not exist.';
END

BEGIN TRANSACTION;

BEGIN TRY
    -- 插入操作
    INSERT INTO Orders (CustomerID, OrderDate) VALUES (@CustomerID, GETDATE());
    
    COMMIT TRANSACTION;
END TRY
BEGIN CATCH
    ROLLBACK TRANSACTION;
    PRINT ERROR_MESSAGE();
END CATCH

ALTER TABLE Orders
ADD CONSTRAINT FK_Orders_Customers
FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID) ON DELETE CASCADE;

BEGIN TRY
    -- 数据库操作
END TRY
BEGIN CATCH
    INSERT INTO ErrorLog (ErrorMessage, ErrorTime) VALUES (ERROR_MESSAGE(), GETDATE());
    PRINT ERROR_MESSAGE();
END CATCH