SQL server 实现有则更新，无则插入

SQL server 实现有则更新，无则插入

数据库中有对应的数据记录则更新数据，无对应的数据记录则插入数据。

if exists(select saleId from Photo_Sale_Picture where saleId = @saleId)

UPDATE Photo_Sale_Picture 
SET SaleId=@saleId,UsingRange=@usingRange,IsPortrait=@isPortrait,MarketPrice=@marketPrice,
CopyrightPrice=@copyrightPrice,UsingPrice=@usingPrice,SystemColumnID=@systemColumnId,
PortraitImg=@portraitImg 
where SaleId=@saleId;

else 

insert into Photo_Sale_Picture(SaleId,UsingRange,IsPortrait,MarketPrice,
CopyrightPrice,UsingPrice,SystemColumnID,PortraitImg) 
values(@saleId,@usingRange,@isPortrait,@marketPrice,@copyrightPrice,
@usingPrice,@systemColumnId,@portraitImg);

posted on 2016-08-12 16:31  代码养家 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/wangzl1163/p/6341148.html