简单的添加更新语句 一条语句实现

declare @C_ID varchar(36)
set @C_ID='4d2c77ef---------'
declare @N_ID varchar(36)
set @N_ID='4d2c77ef'
declare @N_TITLE varchar(36)
set @N_TITLE='4d2c77ef'
declare @N_SORT int
set @N_SORT=1
declare @N_CONTENT varchar(36)
set @N_CONTENT='4d2c77ef'
if exists(select 1 from Dynamicnews where N_ID=@N_ID) begin update Dynamicnews set [N_TITLE]=@N_TITLE,[N_CONTENT]=@N_CONTENT,[N_SORT]=@N_SORT where N_ID=@N_ID end else begin insert into Dynamicnews([C_ID],[N_TITLE],[N_CONTENT],[N_SORT]) values(@C_ID,@N_TITLE,@N_CONTENT,@N_SORT) end

转载于:https://www.cnblogs.com/wangdetian168/archive/2009/04/08/1431819.html