{"id":122,"date":"2023-02-03T16:24:23","date_gmt":"2023-02-03T08:24:23","guid":{"rendered":"https:\/\/www.hgos.top\/?p=122"},"modified":"2023-02-03T16:24:23","modified_gmt":"2023-02-03T08:24:23","slug":"sqlserver-%e5%b8%b8%e7%94%a8%e5%91%bd%e4%bb%a4","status":"publish","type":"post","link":"https:\/\/bbs.hgos.top\/?p=122","title":{"rendered":"Sqlserver \u5e38\u7528\u547d\u4ee4"},"content":{"rendered":"<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"atomic\">--\u89e6\u53d1\u5668\nBEGIN\n    IF\n        UPDATE ( sale_order_line_id ) BEGIN\n            UPDATE stock_move_line \n            SET contract = ( SELECT origin FROM sale_order WHERE ID = ( SELECT sale_order_id FROM sale_order_line WHERE ID = inserted.sale_order_line_id ) )\n        FROM\n            inserted \n        WHERE\n            stock_move_line.ID = inserted.ID \n            AND\n            inserted.sale_order_line_id &gt; 0\n    END\nEND\n\n--\u66ff\u6362\u51fd\u6570\nREPLACE('\u4f60\u597d\u554a', '\u554a', '');\n\n--\u65e5\u671f\n( nvarchar ( 80 ), a.date, 11 ) AS \u65e5\u671f;--\u8f6c\u6362\u4e3a\u65e5\u671f\u4e3a 23\/01\/13<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;\u89e6\u53d1\u5668 BEGIN IF UPDATE ( sale_order_line_id ) BEGIN UPDATE stock_move_line SET contract = ( SELECT origin FROM sale_order [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[17,6],"class_list":["post-122","post","type-post","status-publish","format-standard","hentry","category-sql","tag-sql","tag-jq"],"_links":{"self":[{"href":"https:\/\/bbs.hgos.top\/index.php?rest_route=\/wp\/v2\/posts\/122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bbs.hgos.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bbs.hgos.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bbs.hgos.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bbs.hgos.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=122"}],"version-history":[{"count":1,"href":"https:\/\/bbs.hgos.top\/index.php?rest_route=\/wp\/v2\/posts\/122\/revisions"}],"predecessor-version":[{"id":123,"href":"https:\/\/bbs.hgos.top\/index.php?rest_route=\/wp\/v2\/posts\/122\/revisions\/123"}],"wp:attachment":[{"href":"https:\/\/bbs.hgos.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bbs.hgos.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bbs.hgos.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}