{"id":1759,"date":"2021-12-01T13:03:11","date_gmt":"2021-12-01T04:03:11","guid":{"rendered":"https:\/\/www.kwonline.org\/memo2\/?p=1759"},"modified":"2021-12-01T13:13:53","modified_gmt":"2021-12-01T04:13:53","slug":"tsql-merge","status":"publish","type":"post","link":"https:\/\/www.kwonline.org\/memo2\/2021\/12\/01\/tsql-merge\/","title":{"rendered":"T-SQL \u3067 MERGE"},"content":{"rendered":"<p>&nbsp;<br \/>\nSQL Server \u3067 MERGE \u3092\u3084\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nMERGE &#x5B;my_tbl] AS t1 \r\nUSING &#x5B;my_tmp] AS t2\r\nON t1.&#x5B;mykey] = t2.&#x5B;mykey]\r\nWHEN MATCHED THEN\r\nUPDATE SET t1.&#x5B;hoge] = t2.&#x5B;hoge], t1.&#x5B;fuga] = t2.&#x5B;fuga]\r\nWHEN NOT MATCHED BY TARGET THEN\r\nINSERT(&#x5B;mykey], &#x5B;hoge], &#x5B;fuga])\r\nVALUES(t2.&#x5B;mykey], t2.&#x5B;hoge], t2.&#x5B;fuga]);\r\n<\/pre>\n<p>&nbsp;<br \/>\n\u524d\u306b\u3084\u3063\u305f PostgreSQL \u3067\u306e\u65b9\u6cd5\u306f\u3053\u308c\u2193<br \/>\n<a href=\"https:\/\/www.kwonline.org\/memo2\/2021\/09\/09\/something-similir-to-merge-on-postgresql\/\" rel=\"noopener\" target=\"_blank\">PostgreSQL 12 \u3067 Merge \u3063\u307d\u3044\u4e8b\u3092\u3084\u308b<\/a><br \/>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; SQL Server \u3067 MERGE \u3092\u3084\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002 MERGE &#x5B;my_tbl] AS t1 USING &#x5B;my_tmp] AS t2 ON t1.&#x5B;mykey] = t [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,20,24,23],"tags":[],"class_list":["post-1759","post","type-post","status-publish","format-standard","hentry","category-azure","category-sql","category-sql-server","category-t-sql"],"_links":{"self":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1759","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/comments?post=1759"}],"version-history":[{"count":2,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1759\/revisions"}],"predecessor-version":[{"id":1761,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1759\/revisions\/1761"}],"wp:attachment":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/media?parent=1759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/categories?post=1759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/tags?post=1759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}