创建一个before触发器,每次执行insert的时候create triger tr_reInserton testbefor insertasbeginif exists(select * from test where phone=@phone) rollback transelse insert into test values(..)end
