SQL Server上INSERT或UPDATE的解决方案

INSERT INTO table (column1, column2, column3)
VALUES (value1, value2, value3)
ON DUPLICATE KEY UPDATE column4 = new_value4, column5 = new_value5;

CREATE TRIGGER my_trigger
AFTER INSERT ON table
FOR EACH ROW
BEGIN
    -- 对现有记录的更新或插入
    UPDATE table
    SET column = new_value
    WHERE column2 = new_value2;

    -- 为INSERT的失败处理编写代码
    IF ROW_COUNT() <> 1
    BEGIN
        RAISERROR ('Duplicate entry', 16, 10);
        ROLLBACK TRANSACTION;
    END;
END;

START TRANSACTION;
INSERT INTO table (id, name)
SELECT id + 1, 'New Name'
FROM table
WHERE not exists (
    SELECT NULL
    FROM dbo.next_name
    WHERE table.name = next_name.name
);
UPDATE table
SET id = id + 1
WHERE id % 2 = 0;
COMMIT;