八度空間

--新增Customer表后執行下面觸發器tgr_Customer_Insert

create  trigger   tgr_Customer_Insert
on  Customer
after insert
as
begin
declare @cCusCode varchar(20)
select @cCusCode=cCusCode from inserted--獲取insert后的客戶編碼
update Customer set cCusSAProtocol=cCusDefine2,cCusRegCode=cCusDefine1 where cCusCode=@cCusCode
end

--刪除student表某一條數據后執行下面觸發器  select * from deleted 當前刪除的表記錄信息（字段跟原表一樣） 
create trigger trig_student_delete
on student 
after delete
as
begin
    select stu_id as 已刪除的學生編號,stu_name stu_gender,stu_age
    from deleted
end;
---------------------------------查詢觸發器------------------------------------------------------------
SELECT * FROM SYSOBJECTS WHERE XTYPE='TR' AND parent_obj = OBJECT_ID('Customer') 查詢Customer表所有觸發器
-----------------------修改觸發器---------------------------------

alter trigger   tgr_Customer_Insert 
on  Customer 
after insert 
as 
begin 
declare @cCusCode varchar(20)
select @cCusCode=cCusCode from inserted--獲取insert后的客戶編碼
update Customer set cCusSAProtocol=cCusDefine2,cCusRegCode=cCusDefine1 where cCusCode=@cCusCode
end

------------恢復內容結束------------