Trigger
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER TRIGGER [dbo].[mlsCheckAutoDetailSave]
ON [dbo].[AutoDetailSave]
FOR INSERT, UPDATE
AS
BEGIN
IF NOT EXISTS
(
SELECT resultsNumber
FROM RESULTS_IDX
WHERE resultsNumber = (SELECT MLS FROM INSERTED)
)
BEGIN
RAISERROR('Transaction Failed.',16,1)
ROLLBACK TRAN
END
END
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER TRIGGER [dbo].[mlsCheckAutoDetailSave]
ON [dbo].[AutoDetailSave]
FOR INSERT, UPDATE
AS
BEGIN
IF NOT EXISTS
(
SELECT resultsNumber
FROM RESULTS_IDX
WHERE resultsNumber = (SELECT MLS FROM INSERTED)
)
BEGIN
RAISERROR('Transaction Failed.',16,1)
ROLLBACK TRAN
END
END