sqlserver2008基础编程2—触发器

-- 触发器 添加用户时触发
create trigger tri_add
after insert on users 
for each row
BEGIN
	insert into click values (null,new.u_id,1,0);
	insert into limits values (null,new.u_id,1,0);
END
 -- drop TRIGGER tri_add;
 
-- 触发器 删除用户时触发
create trigger tri_del
after DELETE on users 
for each row
BEGIN
	delete from click where c_u_id = old.u_id;
	delete from limits where l_u_id = old.u_id;
END
 -- drop TRIGGER tri_del;
 
-- 触发器 更新用户时触发
create trigger tri_update
after update on users 
for each row
BEGIN
	update emigrated set e_user = new.u_name where e_user = old.u_name;
	update fight set f_user = new.u_name where f_user = old.u_name;
END
 -- drop TRIGGER tri_update;