轻松掌握设计Sql Server触发器的原理 （7）

use northwind
go
create trigger order_insert6
on order_test
after insert
as
if 
(select count(*) from cust_test,inserted
where cust_test.customerid=inserted.customerid)<>@@rowcount
--可以在触发器逻辑中使用 @@ROWCOUNT 函数以区分单行插入和多行插入。
begin
delete order_test from order_test,inserted
where order_test.orderid=inserted.orderid and
inserted.customerid not in (select customerid from cust_test)
end

print @@rowcount

SET ROWCOUNT { number | @number_var }

number | @number_var