欢迎您访问 最编程 本站为您分享编程语言代码，编程技术文章！

热门搜索/Hot Search

您现在的位置是： 首页

在SQL Server中，类似MySQL的REPLACE INTO操作：如何实现REPLACE INTO功能

最编程 2024-07-23 13:40:09
...
<insert id="insertListMssql">
    INSERT INTO mch_info(<include refid="Base_Column_List"/>)
    SELECT * FROM ( VALUES
    <foreach collection="list" index="i" separator="," item="item">
        (
        #{item.mchId},
        #{item.mchName},
        )
    </foreach>
    ) AS mch_info_temp (<include refid="Base_Column_List"/>)
    WHERE NOT EXISTS (SELECT 1 FROM mch_info WHERE mch_info.mchId = mch_info_temp.mchId)
</insert>

<insert id="updateListMssql">
    UPDATE mch_info SET
    mch_info.mchName = mch_info_temp.mchName
    FROM mch_info ,(SELECT * FROM ( VALUES
    <foreach collection="list" index="i" separator="," item="item">
        (
        #{item.mchId},
        #{item.mchName}
        )
    </foreach>
    ) AS temp (<include refid="Base_Column_List"/>)) AS mch_info_temp
    WHERE mch_info.mchId = mch_info_temp.mchId
</insert>

上一篇： Cohere for AI 现推出 Aya：一款支持100多种语言的强大语言模型

下一篇： 在Ubuntu Linux中快速搭建Nginx环境指南

推荐阅读