{"id":2920,"date":"2013-11-16T03:26:01","date_gmt":"2013-11-16T03:26:01","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2920"},"modified":"2013-11-16T03:26:01","modified_gmt":"2013-11-16T03:26:01","slug":"%e5%8d%b3%e6%97%b6%e8%ae%be%e7%bd%ae%e6%95%b0%e6%8d%ae%e5%ba%93%e7%8a%b6%e6%80%81","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/11\/16\/%e5%8d%b3%e6%97%b6%e8%ae%be%e7%bd%ae%e6%95%b0%e6%8d%ae%e5%ba%93%e7%8a%b6%e6%80%81\/","title":{"rendered":"\u5373\u65f6\u8bbe\u7f6e\u6570\u636e\u5e93\u72b6\u6001"},"content":{"rendered":"<p>\u5728\u8bbe\u7f6e\u6570\u636e\u5e93\u72b6\u6001\u65f6<br \/>\nwith\u5b50\u53e5\u5ffd\u7565\uff0c\u5219\u5f53\u6570\u636e\u5e93\u4e2d\u5b58\u5728\u4efb\u4f55\u9501\u65f6\uff0cALTER DATABASE \u8bed\u53e5\u5c06\u65e0\u9650\u671f\u7b49\u5f85\u3002<br \/>\nwith&nbsp;NO_WAIT \uff0c\u6307\u5b9a\u82e5\u6709\u4e8b\u52a1\u8fd8\u6ca1\u6709\u63d0\u4ea4\uff0c\u5219\u7acb\u5373\u5931\u8d25\uff0c\u4e0d\u518d\u8fdb\u884c\u4e0b\u9762\u7684\u64cd\u4f5c<br \/>\nwith&nbsp;ROLLBACK AFTER integer [SECONDS] | ROLLBACK IMMEDIATE:\u6307\u5b9a\u662f\u5728\u6307\u5b9a\u79d2\u6570\u4e4b\u540e\u56de\u6eda\u8fd8\u662f\u7acb\u5373\u56de\u6eda\u3002<\/p>\n<p>\u6ce8\u610f\uff1a<span style=\"color: rgb(42, 42, 42); font-family: 'Microsoft YaHei UI', 'Microsoft YaHei', SimSun, 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18px; background-color: rgb(255, 255, 225);\">\u5e76\u975e\u6240\u6709\u6570\u636e\u5e93\u9009\u9879\u90fd\u4f7f\u7528 WITH &lt;termination&gt; \u5b50\u53e5\uff0c\u4e5f\u4e0d\u662f\u6240\u6709\u6570\u636e\u5e93\u9009\u9879\u90fd\u80fd\u7ed3\u5408\u5176\u4ed6\u9009\u9879\u6307\u5b9a\u3002<\/span><\/p>\n<pre style=\"padding: 5px; margin-top: 0px; margin-bottom: 0px; overflow: auto; word-wrap: normal; font-size: 13px; line-height: 17px; font-family: Consolas, Courier, monospace !important;\">\r\nALTER DATABASE AdventureWorks2012\r\nSET SINGLE_USER\r\nWITH ROLLBACK IMMEDIATE;\r\nGO\r\nALTER DATABASE AdventureWorks2012\r\nSET READ_ONLY\r\nGO\r\nALTER DATABASE AdventureWorks2012\r\nSET MULTI_USER;\r\nGO\r\n\r\n\r\n<\/pre>\n<p>\n<a href=\"http:\/\/msdn.microsoft.com\/zh-cn\/library\/bb522682(v=sql.120).aspx\">ALTER DATABASE SET \u9009\u9879 (Transact-SQL)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u8bbe\u7f6e\u6570\u636e\u5e93\u72b6\u6001\u65f6 with\u5b50\u53e5\u5ffd\u7565\uff0c\u5219\u5f53\u6570\u636e\u5e93\u4e2d\u5b58\u5728\u4efb\u4f55\u9501\u65f6\uff0cALTER DATABASE \u8bed\u53e5\u5c06\u65e0\u9650\u671f\u7b49\u5f85 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2920","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2920","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2920"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2920\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2920"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}