insert into Client2Other (F01, F02, F03, F04....F12) SELECT #{F01}, #{F02}, #{F03}, #{F04},.....#{F12},MSSQL,改成不存在,插入,存在修改,F01一直到F12,你给我的要写完整
时间: 2023-11-01 09:19:12 浏览: 39
好的,根据你的要求,完整的 SQL 语句如下:
```
IF EXISTS (SELECT * FROM Client2Other WHERE F01=#{F01} AND F02=#{F02} AND F03=#{F03} AND F04=#{F04} AND F05=#{F05} AND F06=#{F06} AND F07=#{F07} AND F08=#{F08} AND F09=#{F09} AND F10=#{F10} AND F11=#{F11} AND F12=#{F12})
BEGIN
UPDATE Client2Other SET F02=#{F02}, F03=#{F03}, F04=#{F04}, F05=#{F05}, F06=#{F06}, F07=#{F07}, F08=#{F08}, F09=#{F09}, F10=#{F10}, F11=#{F11}, F12=#{F12} WHERE F01=#{F01} AND F02=#{F02} AND F03=#{F03} AND F04=#{F04} AND F05=#{F05} AND F06=#{F06} AND F07=#{F07} AND F08=#{F08} AND F09=#{F09} AND F10=#{F10} AND F11=#{F11} AND F12=#{F12}
END
ELSE
BEGIN
INSERT INTO Client2Other (F01, F02, F03, F04, F05, F06, F07, F08, F09, F10, F11, F12) VALUES (#{F01}, #{F02}, #{F03}, #{F04}, #{F05}, #{F06}, #{F07}, #{F08}, #{F09}, #{F10}, #{F11}, #{F12})
END
```
这个 SQL 语句首先判断表中是否存在与要插入的数据相同的记录,如果存在则更新已有记录,否则插入新数据。其中 F01-F12 是表中的字段名,#{F01}-#{F12} 是要插入/更新的具体数据值。