IF (SELECT count(*) FROM Data as t INNER JOIN Inserted as i ON i.DataContent = t.DataContent ) > 1 和你的问题一样 http://community.csdn.net/Expert/topic/5553/5553102.xml?temp=.872555
请问wgzaaa() if exists (select 1 from inserted AS A join xxx AS B on A.xxx=B.xxx) 在insert 触发器中为何不行?
IF (SELECT count(*) FROM Data as t INNER JOIN Inserted as i ON i.DataContent = t.DataContent ) > 1 可以用的 回复是还没看到 if exists (select 1 from inserted AS A join xxx AS B on A.xxx=B.xxx) 在insert 触发器中为何不行?
on xxx
for insert
as
begin tran
if exists (select 1 from inserted AS A join xxx AS B on A.xxx=B.xxx)
rollback
else
commit tran
add constratint cons_name unique(字段名)
ON i.DataContent = t.DataContent ) > 1
和你的问题一样
http://community.csdn.net/Expert/topic/5553/5553102.xml?temp=.872555
ON i.DataContent = t.DataContent ) > 1
可以用的
回复是还没看到
if exists (select 1 from inserted AS A join xxx AS B on A.xxx=B.xxx) 在insert 触发器中为何不行?