{"id":1539,"date":"2023-07-11T11:45:38","date_gmt":"2023-07-11T03:45:38","guid":{"rendered":"http:\/\/www.haoht.com.cn\/?p=1539"},"modified":"2023-07-11T11:46:35","modified_gmt":"2023-07-11T03:46:35","slug":"%e8%a7%a3%e9%99%a4%e6%9f%90%e4%b8%80%e4%b8%aa%e6%95%b0%e6%8d%ae%e5%ba%93%e8%a2%ab%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%8d%a0%e7%94%a8%e7%9a%84%e6%83%85%e5%86%b5","status":"publish","type":"post","link":"http:\/\/www.haoht.com.cn\/1539\/","title":{"rendered":"\u89e3\u9664\u67d0\u4e00\u4e2a\u6570\u636e\u5e93\u88ab\u5e94\u7528\u7a0b\u5e8f\u5360\u7528\u7684\u60c5\u51b5"},"content":{"rendered":"<p>&#8212;&#8212; \u89e3\u9664\u6570\u636e\u5e93\u5360\u7528<br \/>\nuse master<br \/>\ngo<\/p>\n<p>declare @dbname sysname<br \/>\nset @dbname=&#8217;OIMobox&#8217; &#8211;\u4e0d\u80fd\u5220\u9664\uff0c\u6216\u4e0d\u80fd \u8fd8\u539f\u7684\u6570\u636e\u5e93<\/p>\n<p>declare @s nvarchar(1000)<br \/>\ndeclare tb cursor local for<br \/>\nselect s=&#8217;kill &#8216;+cast(spid as varchar)<br \/>\nfrom master..sysprocesses<br \/>\nwhere dbid=db_id(@dbname)<\/p>\n<p>open tb<br \/>\nfetch next from tb into @s<br \/>\nwhile @@fetch_status=0<br \/>\nbegin<br \/>\nexec(@s)<br \/>\nfetch next from tb into @s<br \/>\nend<br \/>\nclose tb<br \/>\ndeallocate tb<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8212;&#8212; \u89e3\u9664\u6570\u636e\u5e93\u5360\u7528 use master go declare @dbname sy [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1415,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,4,33],"tags":[16,17],"class_list":["post-1539","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pcenter","category-shishi","category-wentizx","tag-shouce","tag-fangan"],"_links":{"self":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/1539","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/comments?post=1539"}],"version-history":[{"count":1,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/1539\/revisions"}],"predecessor-version":[{"id":1541,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/1539\/revisions\/1541"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/media\/1415"}],"wp:attachment":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/media?parent=1539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/categories?post=1539"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/tags?post=1539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}