{"id":2632,"date":"2013-04-23T08:42:18","date_gmt":"2013-04-23T08:42:18","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2632"},"modified":"2013-04-23T08:42:18","modified_gmt":"2013-04-23T08:42:18","slug":"%e6%9f%a5%e7%9c%8btfs%e7%9a%84%e7%ad%be%e5%85%a5%e8%ae%b0%e5%bd%95","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/04\/23\/%e6%9f%a5%e7%9c%8btfs%e7%9a%84%e7%ad%be%e5%85%a5%e8%ae%b0%e5%bd%95\/","title":{"rendered":"\u67e5\u770bTFS\u7684\u7b7e\u5165\u8bb0\u5f55"},"content":{"rendered":"<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\n\r\nSELECT c.ParentPath,c.ChildItem,\r\nc2.SamAccountName,\r\nDATEADD(hh,8,cs.CreationDate) CreationDate,\r\ncs.Comment\r\nFROM    tbl_Version c\r\nJOIN    tbl_Changeset cs\r\nON      cs.ChangeSetId = c.VersionFrom\r\nJOIN    tbl_Identity owner\r\nON      owner.IdentityId = cs.OwnerId\r\nJOIN ADObjects c2 ON c2.TeamFoundationId = owner.TeamFoundationId\r\nLEFT JOIN tbl_Identity committer\r\nON      committer.IdentityId = cs.CommitterId\r\nLEFT JOIN tbl_PolicyOverride po\r\nON      po.ChangeSetId = cs.ChangeSetId\r\n--WHERE   cs.CreationDate &gt;= DATEADD(hh,-8,CONVERT(VARCHAR(10),GETDATE(),120))\r\nORDER BY CreationDate DESC\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SELECT c.ParentPath,c.ChildItem, c2.SamAccountName, DAT [&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-2632","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\/2632","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=2632"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2632\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}