SQL语句 新增前判断
来源:互联网 发布:mac怎么用word 编辑:程序博客网 时间:2024/05/22 15:13
如果发现数据表中存在某条记录则更新,如果不存在就增加一条记录
if exists (select FuXiu_XueShengID,FuXiu_BanJiShouKeID from FuXiu_XueShengChengJiwhere FuXiu_XueShengID=@FuXiu_XueShengID and FuXiu_BanJiShouKeID=@FuXiu_BanJiShouKeID)
update FuXiu_XueShengChengJi
set FuXiuKeChengJiaoShiID=@JiaoShiID,FuXiu_BanJiShouKeID=@FuXiu_BanJiShouKeID,FuXiu_XueShengID=@FuXiu_XueShengID
,ChengJiCiShuLeiBie=@ChengJiCiShuLeiBie,ChengJiZongPing=@ChengJiZongPing
,PingShiZongPing=@PingShiZongPing,ShiJuanZongPing=@ShiJuanZongPing,PingYu=@PingYu
where FuXiu_XueShengChengJi.FuXiuKeChengJiaoShiID=@JiaoShiID
and FuXiu_XueShengChengJi.FuXiu_BanJiShouKeID=@FuXiu_BanJiShouKeID
and FuXiu_XueShengChengJi.FuXiu_XueShengID=@FuXiu_XueShengID
and FuXiu_XueShengChengJi.ChengJiCiShuLeiBie=@ChengJiCiShuLeiBie
else
insert into FuXiu_XueShengChengJi(FuXiu_XueShengID,FuXiu_BanJiShouKeID,FuXiuKeChengJiaoShiID,ChengJiCiShuLeiBie
,ChengJiZongPing,PingShiZongPing,ShiJuanZongPing,PingYu)
values (@FuXiu_XueShengID,@FuXiu_BanJiShouKeID,@JiaoShiID,@ChengJiCiShuLeiBie,@ChengJiZongPing
,@PingShiZongPing,@ShiJuanZongPing,@PingYu)
- SQL语句 新增前判断
- sql server 新增字段sql语句
- 重复执行sql语句前的判断参考-仅供自己备忘参考
- SQL条件判断语句
- SQL条件判断语句
- sql常用判断语句
- SQL常用判断语句
- sql常用判断语句
- sql判断语句
- SQL语句判断
- SQL 常用判断语句
- java自动生成mybatis新增sql语句
- sql语句给数据库表新增字段
- sql语句前加入explain优化sql
- 判断sql语句是否安全
- sql语句判断范围区间
- pl/sql常用判断语句
- sql 语句加判断规则
- 移植U-Boot.1.2.0到友善之臂S3C2440(1)
- 移植U-Boot.1.2.0到友善之臂S3C2440 (2)
- 白话PID控制
- win7下更改设置时间权限
- C++ _int64 G++ long long 用法
- SQL语句 新增前判断
- 项目基线的理解
- SSL服务端与客户端
- 一个面试题
- 减速器-sleep、pause
- 敏捷个人和敏捷开发
- C# ArrayList的使用
- 匹配问题汇总
- rhythmbox添加网络电台