create trigger update_directory
on directory
for update,delete
as
begin
if(@@rowcount > 1)
insert into Log(LogMessage,LogCount) values('ad',@@rowcount)
end功能:对其它的表做操作的时候, 如果影响的记录数大于1,就记录到另一个表Log中
语法可以通过 但插入到数据表里都是0
on directory
for update,delete
as
begin
if(@@rowcount > 1)
insert into Log(LogMessage,LogCount) values('ad',@@rowcount)
end功能:对其它的表做操作的时候, 如果影响的记录数大于1,就记录到另一个表Log中
语法可以通过 但插入到数据表里都是0
on directory
for update,delete
as
begin
declare @cnt int
set @cnt=@@rowcount
if(@cnt> 1)
insert into Log(LogMessage,LogCount) values('ad',@cnt)
end
on directory
for update,delete
as
begin
insert into Log(LogMessage,LogCount) select 'ad',@@rowcount where @@rowcount>0
end