{"id":74,"date":"2011-01-17T21:55:00","date_gmt":"2011-01-17T13:55:00","guid":{"rendered":"http:\/\/localhost\/?p=26"},"modified":"2013-12-30T10:38:18","modified_gmt":"2013-12-30T02:38:18","slug":"preventing_the_trigger_table_is_deleted","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=74","title":{"rendered":"\u9632\u6b62\u8868\u88ab\u5220\u9664\u7684\u89e6\u53d1\u5668"},"content":{"rendered":"<p><span style=\"font-family: courier new,courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u95ee\u9898<\/span><span lang=\"en-US\">:<\/span><span lang=\"zh-CN\">\u5982\u4f55\u9632\u6b62\u6570\u636e\u5e93\u4e2d\u8868\u88ab\u5220\u9664<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u9664\u4e86\u63a7\u5236\u6743\u9650<\/span><span lang=\"en-US\">(<\/span><span lang=\"zh-CN\">\u767b\u5f55\u8d26\u6237\u6ca1\u6709\u5220\u9664\u8868\u7684\u6743\u9650<\/span><span lang=\"en-US\">)<\/span><span lang=\"zh-CN\">\u4e4b\u5916\u8fd8\u53ef\u4ee5\u901a\u8fc7\u521b\u5efa\u89e6\u53d1\u5668\u5b9e\u73b0<\/span><\/span><\/span><\/p>\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: courier new,courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u521b\u5efa\u89e6\u53d1\u5668\u65b9\u6cd5<\/span><span lang=\"en-US\">:<\/span><\/span><\/span><\/p>\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: courier new,courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\">1.<\/span><span lang=\"zh-CN\">\u521b\u5efa\u4e00\u4e2a\u6570\u636e\u5e93\u7ea7\u522b\u7684\u89e6\u53d1\u5668<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u9632\u6b62\u8868\u88ab\u8bef\u5220\u9664<\/span><\/span><\/span><\/p>\n<p style=\"MARGIN: 0in; FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\"><textarea cols=\"50\" rows=\"15\" name=\"code\" class=\"c-sharp\">&#8212; \u963b\u6b62\u5220\u9664\u8868\u7684\u89e6\u53d1\u5668<br \/>\nCREATE TRIGGER DenyDropTable<br \/>\nON DATABASE<br \/>\nFOR DROP_TABLE<br \/>\nAS<br \/>\nIF EVENTDATA().value(&#8216;(\/EVENT_INSTANCE\/ObjectName)[1]&#8217;, &#8216;NVARCHAR(MAX)&#8217;) IN (&#8216;DatabaseModifiedLog&#8217;)<br \/>\n   BEGIN<br \/>\n      ROLLBACK<br \/>\n   END<br \/>\nGO<\/textarea><span style=\"font-family: courier new,courier;\"><span style=\"font-size: small;\"> <\/span><\/span><\/p>\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: courier new,courier;\"><span style=\"font-size: small;\">&nbsp;<\/span><\/span><\/p>\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: courier new,courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\">2.<\/span><span lang=\"zh-CN\">\u5f53\u5220\u9664\u8868\u65f6\u4f1a\u6709\u5982\u4e0b\u56fe\u63d0\u793a<\/span><span lang=\"en-US\">:<\/span><\/span><\/span><\/p>\n<p style=\"margin: 0in;\"><span style=\"font-family: courier new,courier;\"><span style=\"font-size: small;\">&nbsp;<img decoding=\"async\" src=\"http:\/\/localhost\/wp-content\/uploads\/pic\/0_1295272432XWoe.gif\" alt=\"\" \/><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u95ee\u9898:\u5982\u4f55\u9632\u6b62\u6570\u636e\u5e93\u4e2d\u8868\u88ab\u5220\u9664,\u9664\u4e86\u63a7\u5236\u6743\u9650(\u767b\u5f55\u8d26\u6237\u6ca1\u6709\u5220\u9664\u8868\u7684\u6743\u9650)\u4e4b\u5916\u8fd8\u53ef\u4ee5\u901a\u8fc7\u521b\u5efa\u89e6\u53d1\u5668\u5b9e\u73b0 \u521b\u5efa\u89e6\u53d1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[16],"class_list":["post-74","post","type-post","status-publish","format-standard","hentry","category-sqlserver","tag-sql_server_2008_r2"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/74","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=74"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/74\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=74"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=74"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}