if u have primary key on table then just the trap the error by

@@ERROR

and generate error with RAISERROR ('Duplicate Record')