My question is why you are adding a trigger to check existing records.
you can just check in query in same sp that is you are using to inserts records in db table.
to create trigger you can write code as
CREATE TRIGGER trgname
BEFORE INSERT ON my_table_name
FOR EACH ROW
IF something THEN