{"id":2820,"date":"2024-06-07T15:42:13","date_gmt":"2024-06-07T07:42:13","guid":{"rendered":"http:\/\/www.plm.cn\/?p=2820"},"modified":"2024-06-07T15:42:13","modified_gmt":"2024-06-07T07:42:13","slug":"sqlserver%e6%95%b0%e6%8d%ae%e5%ba%93%e8%a2%ab%e5%8d%a0%e7%94%a8%ef%bc%8c%e9%80%a0%e6%88%90%e6%97%a0%e6%b3%95%e8%bf%98%e5%8e%9f%e6%88%96%e5%88%a0%e9%99%a4%e7%9a%84%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"http:\/\/www.plm.cn\/2820\/","title":{"rendered":"SQLServer\u6570\u636e\u5e93\u88ab\u5360\u7528\uff0c\u9020\u6210\u65e0\u6cd5\u8fd8\u539f\u6216\u5220\u9664\u7684\u89e3\u51b3\u65b9\u6cd5"},"content":{"rendered":"<div>SQLServer\u6570\u636e\u5e93\u7684\u65f6\u5019\u53ef\u80fd\u88ab\u522b\u7684\u7a0b\u5e8f\u5360\u7528\uff0c\u800c\u9020\u6210\u65e0\u6cd5\u8fd8\u539f\u6216\u5220\u9664\uff0c\u8fd9\u91cc\u6709\u4e00\u4e2a\u7b80\u5355\u811a\u672c\uff0c\u6267\u884c\u540e\u80fd\u89e3\u51b3\uff08 \u5c06\u811a\u672c\u91cc\u9762 AM \u66ff\u6362\u4e3a \u4f60\u7684\u76ee\u6807\u6570\u636e\u5e93\uff09<\/div>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2821\" src=\"http:\/\/www.plm.cn\/wp-content\/uploads\/2024\/06\/dbzy.png\" alt=\"\" width=\"718\" height=\"435\" srcset=\"http:\/\/www.plm.cn\/wp-content\/uploads\/2024\/06\/dbzy.png 718w, http:\/\/www.plm.cn\/wp-content\/uploads\/2024\/06\/dbzy-300x182.png 300w\" sizes=\"auto, (max-width: 718px) 100vw, 718px\" \/><\/div>\n<div>\u811a\u672c\u9700\u8981\u5728SQL\u7684\u67e5\u8be2\u5206\u6790\u5668\u91cc\u9762\u8fd0\u884c<\/div>\n<div>\n<hr \/>\n<\/div>\n<div>use master<\/div>\n<div>go<\/div>\n<div><\/div>\n<div>declare @dbname sysname<\/div>\n<div>set @dbname=&#8217;AM&#8217; &#8211;\u4e0d\u80fd\u5220\u9664\uff0c\u6216\u4e0d\u80fd \u8fd8\u539f\u7684\u6570\u636e\u5e93<\/div>\n<div><\/div>\n<div>declare @s nvarchar(1000)<\/div>\n<div>declare tb cursor local for<\/div>\n<div>select s=&#8217;kill &#8216;+cast(spid as varchar)<\/div>\n<div>from master..sysprocesses<\/div>\n<div>where dbid=db_id(@dbname)<\/div>\n<div><\/div>\n<div>open tb<\/div>\n<div>fetch next from tb into @s<\/div>\n<div>while @@fetch_status=0<\/div>\n<div>begin<\/div>\n<div>exec(@s)<\/div>\n<div>fetch next from tb into @s<\/div>\n<div>end<\/div>\n<div>close tb<\/div>\n<div>deallocate tb<\/div>\n","protected":false},"excerpt":{"rendered":"<p>SQLServer\u6570\u636e\u5e93\u7684\u65f6\u5019\u53ef\u80fd\u88ab\u522b\u7684\u7a0b\u5e8f\u5360\u7528\uff0c\u800c\u9020\u6210\u65e0\u6cd5\u8fd8\u539f\u6216\u5220\u9664\uff0c\u8fd9\u91cc\u6709\u4e00\u4e2a\u7b80\u5355\u811a\u672c\uff0c\u6267\u884c\u540e\u80fd\u89e3\u51b3\uff08 \u5c06 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2821,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,8],"tags":[],"class_list":["post-2820","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-plmcenter","category-wtcenter"],"_links":{"self":[{"href":"http:\/\/www.plm.cn\/wp-json\/wp\/v2\/posts\/2820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.plm.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.plm.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.plm.cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.plm.cn\/wp-json\/wp\/v2\/comments?post=2820"}],"version-history":[{"count":1,"href":"http:\/\/www.plm.cn\/wp-json\/wp\/v2\/posts\/2820\/revisions"}],"predecessor-version":[{"id":2822,"href":"http:\/\/www.plm.cn\/wp-json\/wp\/v2\/posts\/2820\/revisions\/2822"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.plm.cn\/wp-json\/wp\/v2\/media\/2821"}],"wp:attachment":[{"href":"http:\/\/www.plm.cn\/wp-json\/wp\/v2\/media?parent=2820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.plm.cn\/wp-json\/wp\/v2\/categories?post=2820"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.plm.cn\/wp-json\/wp\/v2\/tags?post=2820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}