05 2024 档案

摘要:// 达梦触发器 CREATE OR REPLACE TRIGGER "K_BASIC"."B_BASE_ENGINEERING_CATEGORY TO B_PROJECT_INVESTMENT" AFTER UPDATE OR INSERT ON "K_BASIC"."B_BASE_ENGINEE 阅读全文 »
posted @ 2024-05-17 17:53 东峰叵,com 阅读(69) 评论(0) 推荐(0) 编辑
摘要:# 达梦数据库实现一条sql判断数据是否存在,如存在则修改,不存在,则新增 MERGE INTO X.TABLE1 T1 USING ( SELECT 3 as id, '名字' as COLUMN_1, 0 as COLUMN_2 FROM DUAL ) T2 ON(T1.id = T2.id) 阅读全文 »
posted @ 2024-05-11 14:25 东峰叵,com 阅读(896) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示