create trigger tgr_Inserton Ainstead of insertasprint 'Hello World'goinsert into A values('100')--在觸發(fā)器之前執(zhí)行插入goselect * from Ago--禁用disable trigger tgr_Insert on A go--啟用觸發(fā)器enable trigger tgr_Insert on Ago