sql触发器插入表内容时检查有无重复记录,有则提示不能插入,无则插入

建议插入动作用存储过程完成。存储过程中的Insert语句前，前加if not exists ()。测试用例： declare @FintterID as int declare @FQty as decimal(10,2) declare @FBatchNo as varchar(20) set @FintterID=1783 set @FQty=137.28 set @FBatchNo='104013213120221005' if not exists (select F