SQL Server觸發(fā)器問題總結(jié)
摘自csdn
這個(gè)帖子主要總結(jié)在觸發(fā)器方面的應(yīng)用。
對(duì)于沒有使用過觸發(fā)器的兄弟可以先看下面關(guān)于使用觸發(fā)器的文章。
http://msdn.microsoft.com/library/chs/default.asp?url=/library/CHS/vdbt7/html/dvtskworkingwithtriggers.asp
大家可以在下面的鏈接來搜索CSDN技術(shù)社區(qū)文檔，很大的技術(shù)寶藏。
http://search.csdn.net/search/null/1/dev/
如何查看數(shù)據(jù)表已有觸發(fā)器
http://topic.csdn.net/t/20050430/11/3977896.html
http://topic.csdn.net/t/20020630/08/838835.html
遞歸觸發(fā)器
遞歸觸發(fā)器資料
http://topic.csdn.net/t/20050524/07/4030396.html
遞歸最大層數(shù)的限制
http://topic.csdn.net/t/20041125/23/3589401.html
如何禁用遞歸調(diào)用觸發(fā)器
http://topic.csdn.net/t/20041116/15/3557957.html
http://topic.csdn.net/t/20050426/16/3968278.html
暫時(shí)禁用觸發(fā)器
http://topic.csdn.net/t/20041207/17/3623631.html
http://topic.csdn.net/t/20041111/09/3542063.html
http://topic.csdn.net/t/20050329/15/3891227.html
一個(gè)表上的多個(gè)觸發(fā)器執(zhí)行順序問題
http://topic.csdn.net/t/20050430/08/3977420.html
http://topic.csdn.net/t/20050127/18/3758856.html
http://topic.csdn.net/t/20050126/00/3753784.html
http://topic.csdn.net/t/20041125/10/3586596.html
http://topic.csdn.net/t/20050308/19/3834956.html
http://topic.csdn.net/t/20041014/20/3457150.html
觸發(fā)器在事務(wù)中應(yīng)用
Commit Trans和Rollback Trans在有觸發(fā)器操作時(shí)的區(qū)別
http://topic.csdn.net/t/20041122/22/3578347.html
同一事務(wù)內(nèi),A表觸發(fā)器能否訪問B表的新增數(shù)據(jù)？
http://topic.csdn.net/t/20050601/11/4050878.html
如何做到不讓觸發(fā)器回滾？
http://topic.csdn.net/t/20041108/00/3530417.html
保證事務(wù)完整
http://topic.csdn.net/t/20050607/10/4064811.html
觸發(fā)器優(yōu)化
http://topic.csdn.net/t/20050709/10/4133236.html
用觸發(fā)器來實(shí)現(xiàn)不同數(shù)據(jù)表的數(shù)據(jù)同步問題
http://topic.csdn.net/t/20041028/09/3498141.html
http://community.csdn.net/Expert/topic/5070/5070302.xml?temp=.8607141
觸發(fā)器舉例
http://topic.csdn.net/t/20020630/10/838981.html
http://www.21cnvip.com/csdn/default.aspx?q=20040116/13/2669472.html
http://community.csdn.net/Expert/TopicView3.asp?id=4934709
http://topic.csdn.net/t/20050507/14/3987221.html
http://community.csdn.net/Expert/topic/5138/5138501.xml?temp=.2209436
http://community.csdn.net/Expert/topic/5113/5113853.xml?temp=.7221643
http://topic.csdn.net/t/20050315/18/3853409.html
http://community.csdn.net/Expert/topic/5054/5054821.xml?temp=4.970729E-03
http://community.csdn.net/Expert/topic/5009/5009634.xml?temp=.937771
http://community.csdn.net/Expert/topic/4976/4976851.xml?temp=.3473169
http://community.csdn.net/Expert/topic/4974/4974416.xml?temp=.639187
http://community.csdn.net/Expert/topic/5121/5121369.xml?temp=.3964502
http://community.csdn.net/Expert/topic/5074/5074503.xml?temp=.4956476
http://community.csdn.net/Expert/topic/5068/5068778.xml?temp=.6653864
http://community.csdn.net/Expert/topic/5104/5104648.xml?temp=.5572168
http://topic.csdn.net/t/20050509/16/3992433.html
http://community.csdn.net/Expert/topic/4773/4773121.xml?temp=.3930628
http://topic.csdn.net/t/20050304/10/3823834.html
批量插入的問題
http://topic.csdn.net/t/20050620/18/4094938.html
http://community.csdn.net/Expert/topic/5052/5052560.xml?temp=.2815973
http://community.csdn.net/Expert/topic/5042/5042276.xml?temp=.6679956
http://topic.csdn.net/t/20050224/17/3804072.html
http://topic.csdn.net/t/20041015/13/3459299.html
其他錯(cuò)誤
在觸發(fā)器中不允許使用ALRER DATABSE
http://topic.csdn.net/t/20050116/19/3729936.html
觸發(fā)器更新引發(fā)的異常'無法為更新行集定位:一些值可能已在最后讀取后改變' http://topic.csdn.net/t/20041224/15/3673909.html
視圖上建觸發(fā)器的問題
http://topic.csdn.net/t/20050308/10/3832843.html
請(qǐng)問怎樣在系統(tǒng)表中建立觸發(fā)器！
http://topic.csdn.net/t/20050509/11/3991598.html
SQL Server2000中的觸發(fā)器能夠時(shí)間觸發(fā)嗎
http://community.csdn.net/Expert/topic/4886/4886913.xml?temp=.241131
觸發(fā)器不能創(chuàng)建!
http://topic.csdn.net/t/20050330/23/3895974.html
在SQL Server的觸發(fā)器中動(dòng)態(tài)生成的SQL語句無法引用inserted和deleted表
http://topic.csdn.net/t/20050118/08/3733426.html
不要讓人修改我的觸發(fā)器
http://topic.csdn.net/t/20050627/17/4108181.html