{"id":2713,"date":"2013-06-13T08:28:47","date_gmt":"2013-06-13T08:28:47","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2713"},"modified":"2013-06-13T08:28:47","modified_gmt":"2013-06-13T08:28:47","slug":"sql%e7%99%bb%e5%bd%95%e8%b4%a6%e5%8f%b7%e5%af%86%e7%a0%81%e6%af%94%e5%af%b9","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/06\/13\/sql%e7%99%bb%e5%bd%95%e8%b4%a6%e5%8f%b7%e5%af%86%e7%a0%81%e6%af%94%e5%af%b9\/","title":{"rendered":"sql\u767b\u5f55\u8d26\u53f7\u5bc6\u7801\u6bd4\u5bf9"},"content":{"rendered":"<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\n--find SQL login with blank passwords\r\nselect name,type_desc,create_date from sys.sql_logins where pwdcompare(&#39;&#39;, password_hash) = 1\r\n\r\n--find SQL login with password same as name\r\nselect name,type_desc,create_date from sys.sql_logins where pwdcompare(name, password_hash) = 1\r\n\r\n--\u6bd4\u5bf9sa\u7684\u5bc6\u7801\u662f\u5426\u4e3a123abc\r\nSELECT TOP 50 * \r\nFROM sys.sql_logins sl\r\nWHERE name = &#39;sa&#39; AND pwdcompare(&#39;123abc&#39;, password_hash) = 1\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;find SQL login with blank passwords select name,type_ [&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-2713","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\/2713","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=2713"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2713\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}