摘要:
--今天帮同事解决一个问题,就是线程插入检测数据重复的问题createtable TblDup(a int)select * from TblDup方案1:create unique indexidx_TblDup_a on TblDup(a)declare @a intset @a=1INSERT INTO TblDup(a) SELECT @aWHERE NOT EXISTS (SELECT a FROM TblDup WHERE a=@a) 方案2BEGIN TRY INSERT into TblDup(a) values(1) END TRY BEGIN CATCH DECLARE.. 阅读全文