sybase 15.7 version



如果一个表中存在就更新，不存在就新增的sql。

15.7后新增的函数 MERGE INTO

MERGE INTO #pay_tmp AS b
 USING #temp_pay AS a
  ON a.order_no = b.order_no
   AND a.order_type = b.order_type
 WHEN Matched
  THEN
   UPDATE
   SET b.payment = (b.payment + a.pay_amt)
 WHEN Not Matched
  THEN
   INSERT(
    order_type
    ,order_no
    ,payment
    )
   values(a.order_type, a.order_no, a.pay_amt)