{"id":2750,"date":"2013-07-01T05:51:47","date_gmt":"2013-07-01T05:51:47","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2750"},"modified":"2013-07-01T06:27:33","modified_gmt":"2013-07-01T06:27:33","slug":"merge%e5%90%88%e5%b9%b6","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/07\/01\/merge%e5%90%88%e5%b9%b6\/","title":{"rendered":"merge\u5408\u5e76\u4e0eoutput\u8f93\u51fa"},"content":{"rendered":"<p>\u4e00\u3001merge<br \/>\n1\uff0c\u5229\u7528merge\u4e0d\u7528\u518d\u5199update&#8230;insert,\u53ef\u4ee5\u76f4\u63a5\u5408\u5e76\u3002<br \/>\n2\uff0c\u53ef\u4ee5\u5c06\u66f4\u6539\u7684\u7ed3\u679c\u4e0e\u66f4\u6539\u524d\u7684\u7ed3\u679c\u8f93\u51fa<br \/>\n3\uff0c\u5728sqlserver2008\u540e\u5f15\u7528\u3002<br \/>\n<span style=\"color: rgb(51, 51, 51); font-family: verdana, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px; background-color: rgb(255, 255, 255);\">4\uff0c\u6e90\u8868\u4e2d\u4e0d\u80fd\u6709\u91cd\u590d\u7684\u8bb0\u5f55<\/p>\n<p>\u53c2\u8003\uff1a<\/span><br \/>\n<a href=\"http:\/\/msdn.microsoft.com\/zh-cn\/library\/bb510625(v=sql.100).aspx\">MERGE (Transact-SQL)<\/a><br \/>\n<a href=\"http:\/\/www.cnblogs.com\/CareySon\/archive\/2012\/03\/07\/2383690.html\">SQL Server\u4e2d\u7684Merge\u5173\u952e\u5b57<\/a><\/p>\n<p>\n\u4e8c\u3001output,\u5728\u63d2\u5165\uff0c\u66f4\u65b0\uff0c\u5220\u9664\u65f6\u8bb0\u5f55<\/p>\n<pre style=\"padding: 5px; margin-top: 0px; margin-bottom: 0px; font-family: Consolas, Courier, monospace; overflow: auto; word-wrap: normal; font-size: 13px; line-height: 17px;\">\r\nDELETE Sales.ShoppingCartItem\r\nOUTPUT DELETED.* \r\nWHERE ShoppingCartID = 20621;<\/pre>\n<p><a href=\"http:\/\/msdn.microsoft.com\/zh-cn\/library\/ms177564(v=sql.100).aspx\">OUTPUT \u5b50\u53e5 (Transact-SQL)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001merge 1\uff0c\u5229\u7528merge\u4e0d\u7528\u518d\u5199update&#8230;insert,\u53ef\u4ee5\u76f4\u63a5\u5408\u5e76\u3002 2\uff0c\u53ef\u4ee5\u5c06\u66f4 [&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-2750","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\/2750","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=2750"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2750\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}