{"id":1201,"date":"2019-08-08T10:09:02","date_gmt":"2019-08-08T02:09:02","guid":{"rendered":"https:\/\/freesilo.com\/?p=1201"},"modified":"2019-09-30T12:55:20","modified_gmt":"2019-09-30T04:55:20","slug":"sqlserver-%e6%9f%a5%e8%af%a2%e5%bd%93%e5%89%8d%e6%95%b0%e6%8d%ae%e5%ba%93%e8%bf%9e%e6%8e%a5%e5%b9%b6%e6%b8%85%e9%99%a4%e6%9c%aa%e5%85%b3%e9%97%ad%e7%9a%84%e8%bf%9e%e6%8e%a5","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=1201","title":{"rendered":"SQLServer \u67e5\u8be2\u5f53\u524d\u6570\u636e\u5e93\u8fde\u63a5\u5e76\u6e05\u9664\u672a\u5173\u95ed\u7684\u8fde\u63a5"},"content":{"rendered":"<p>SQLServer \u67e5\u8be2\u5f53\u524d\u6570\u636e\u5e93\u8fde\u63a5\u5e76\u6e05\u9664\u672a\u5173\u95ed\u7684\u8fde\u63a5<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n--\u67e5\u8be2\u6570\u636e\u5e93\u5b9e\u4f8b\u7684\u6240\u6709\u8fde\u63a5\r\nselect * from master.dbo.sysprocesses where dbid = DB_ID('DBName')\r\n\r\n--\u6e05\u9664\u6307\u5b9a\u5b9e\u4f8b\u7684\u6240\u6709\u6570\u636e\u5e93\u8fde\u63a5\r\nUSE master  \r\ngo   \r\n \r\ndeclare   @programName     nvarchar(200),   \r\n@spid   nvarchar(20)   \r\n   \r\ndeclare   cDblogin   cursor   for  \r\nselect   cast(spid   as   varchar(20))  AS spid   from   master..sysprocesses   where   dbid=db_id('xgj_w1_demo')   \r\nopen   cDblogin  \r\nfetch   next   from   cDblogin   into   @spid   \r\nwhile   @@fetch_status=0   \r\nbegin     \r\n--\u9632\u6b62\u81ea\u5df1\u7ec8\u6b62\u81ea\u5df1\u7684\u8fdb\u7a0b    \r\n--\u5426\u5219\u4f1a\u62a5\u9519\u4e0d\u80fd\u7528KILL \u6765\u7ec8\u6b62\u60a8\u81ea\u5df1\u7684\u8fdb\u7a0b   \r\nIF  @spid &lt;&gt; @@SPID  \r\n    exec( 'kill   '+@spid)   \r\nfetch   next   from  cDblogin   into   @spid   \r\nend      \r\nclose   cDblogin   \r\ndeallocate   cDblogin\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SQLServer \u67e5\u8be2\u5f53\u524d\u6570\u636e\u5e93\u8fde\u63a5\u5e76\u6e05\u9664\u672a\u5173\u95ed\u7684\u8fde\u63a5 &#8211;\u67e5\u8be2\u6570\u636e\u5e93\u5b9e\u4f8b\u7684\u6240&#8230;<br \/><a class=\"read-more-button\" href=\"https:\/\/freesilo.com\/?p=1201\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1201","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/1201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1201"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/1201\/revisions"}],"predecessor-version":[{"id":1202,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/1201\/revisions\/1202"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}