SQL语句 新增前判断

如果发现数据表中存在某条记录则更新，如果不存在就增加一条记录   

if exists (select FuXiu_XueShengID,FuXiu_BanJiShouKeID from FuXiu_XueShengChengJi 
  where 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)