CREATE TRIGGER InsteadTrigger on YourTable
INSTEAD OF INSERT
AS
BEGIN
--check the data in inserted table
if .....
INSERT INTO YourTable
SELECT Col1, Col2,...
FROM inserted
END
GO
CREATE TRIGGER InsteadTrigger on YourTable
INSTEAD OF INSERT
AS
if exists (select 1 from inserted where ....)
begin
INSERT INTO YourTable
SELECT Col1, Col2,...
FROM inserted
end
GO