{"id":91,"date":"2020-06-08T15:03:03","date_gmt":"2020-06-08T07:03:03","guid":{"rendered":"https:\/\/22pig.com\/?p=91"},"modified":"2020-06-08T15:03:03","modified_gmt":"2020-06-08T07:03:03","slug":"%e6%9f%a5%e8%af%a2%e8%a1%a8%e9%94%81%ef%bc%8c%e8%a7%a3%e9%94%81","status":"publish","type":"post","link":"http:\/\/22pig.com\/?p=91","title":{"rendered":"\u67e5\u8be2\u8868\u9501\uff0c\u89e3\u9501"},"content":{"rendered":"<p>&#8211;\u67e5\u8be2\u8868\u9501\uff0c\u89e3\u9501<br \/>\nselect   request_session_id   spid,OBJECT_NAME(resource_associated_entity_id) tableName<br \/>\nfrom   sys.dm_tran_locks where resource_type=&#8217;OBJECT&#8217; <\/p>\n<p>declare @spid  int<br \/>\nSet @spid  = 99 &#8211;\u9501\u8868\u8fdb\u7a0b<br \/>\ndeclare @sql varchar(1000)<br \/>\nset @sql=&#8217;kill &#8216;+cast(@spid  as varchar)<br \/>\nexec(@sql)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;\u67e5\u8be2\u8868\u9501\uff0c\u89e3\u9501 select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type=&#8217;OBJECT&#8217; declare @spid int Set @spid = 99 &#8211;\u9501\u8868\u8fdb\u7a0b declare @sql varchar(1000) set @sql=&#8217;kill &#8216;+cast(@spid as varchar) exec(@sql)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-91","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"_links":{"self":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/91","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=91"}],"version-history":[{"count":0,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/91\/revisions"}],"wp:attachment":[{"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}