触åå¨æ¯ä¸ç§ç¹æ®çåå¨è¿ç¨ï¼ç±»ä¼¼äºå
¶å®ç¼ç¨è¯è¨ä¸çäºä»¶å½æ°ï¼SQL Server? å
许为 INSERTãUPDATEãDELETE å建触åå¨ï¼å½å¨è¡¨ï¼è§å¾ï¼ä¸æå
¥ãæ´æ°ãå é¤è®°å½æ¶ï¼è§¦åä¸ä¸ªæä¸ç³»å T-SQL è¯å¥ã
æ¬ä¸é¢çç®ç并éæ¯åæ¨è¯¦å°½å°ä»ç»è§¦åå¨ï¼èæ¯ç³»ç»å°åæ¨ä»ç»è§¦åå¨ç常ç¨ç¥è¯ä¸ç¸å
³åºç¨ï¼å¹¶ä¸æ¨ä¸èµ·æ¢è®¨åºç¨ç»éªï¼å¦ææ¨éè¦äºè§£è§¦åå¨ä¸å¸¸ç¨çç¥è¯ç¹ï¼è¯·åè§ SQL Server? èæºä¸ä¹¦ï¼å®è£
SQL Server? æ¶é»è®¤æ¯å®è£
çï¼ã
a.åºç¡ï¼å建ä¸ä¸ªç®åç触åå¨
触åå¨æ¯ä¸ç§ç¹æ®çåå¨è¿ç¨ï¼ç±»ä¼¼äºäºä»¶å½æ°ï¼SQL Server? å
许为 INSERTãUPDATEãDELETE å建触åå¨ï¼å³å½å¨è¡¨ä¸æå
¥ãæ´æ°ãå é¤è®°å½æ¶ï¼è§¦åä¸ä¸ªæä¸ç³»å T-SQLè¯å¥ã
触åå¨å¯ä»¥å¨æ¥è¯¢åæå¨éå建ï¼ä¹å¯ä»¥å¨è¡¨åä¸ç¹å³é®->âææä»»å¡â->â管ç触åå¨âæ¥å建ï¼ä¸è¿é½æ¯è¦å T-SQL è¯å¥çï¼åªæ¯å¨æ¥è¯¢åæå¨éè¦å
ç¡®å®å½åæä½çæ°æ®åºã
å建触åå¨ç¨ CREATE TRIGGER
CREATE TRIGGER 触åå¨å称
ON 表å
FOR INSERTãUPDATE æ DELETE
AS
T-SQL è¯å¥
注æï¼è§¦åå¨å称æ¯ä¸å å¼å·çã
å¦ä¸æ¯èæºä¸ä¹¦ä¸çä¸ä¸ªç¤ºä¾ï¼å½å¨ titles 表ä¸æ´æ¹è®°å½æ¶ï¼åéé®ä»¶éç¥ MaryMã
CREATE TRIGGER reminder
ON titles
FOR INSERT, UPDATE, DELETE
AS
EXEC master..xp_sendmail 'MaryM',
'Don''t forget to print a report for the distributors.'
b.åºç¡-å é¤è§¦åå¨
ç¨æ¥è¯¢åæå¨å é¤
å¨æ¥è¯¢åæå¨ä¸ä½¿ç¨ drop trigger 触åå¨å称 æ¥å é¤è§¦åå¨ã
ä¹å¯ä»¥åæ¶å é¤å¤ä¸ªè§¦åå¨ï¼drop trigger 触åå¨å称,触åå¨å称...
注æï¼è§¦åå¨å称æ¯ä¸å å¼å·çãå¨å é¤è§¦åå¨ä¹åå¯ä»¥å
çä¸ä¸è§¦åå¨æ¯å¦åå¨ï¼
if Exists(select name from sysobjects where name=触åå¨å称 and xtype='TR')
ç¨ä¼ä¸ç®¡çå¨å é¤
å¨ä¼ä¸ç®¡çå¨ä¸ï¼å¨è¡¨ä¸ç¹å³é®->âææä»»å¡â->â管ç触åå¨âï¼éä¸æè¦å é¤ç触åå¨ï¼ç¶åç¹å»âå é¤âã
c.åºç¡-éå½å触åå¨ ......
温馨提示:答案为网友推荐,仅供参考