--try drop tb where 主键=@主键 insert tb(主键,...) values(@主键,....)
[code=SQL]create table T( ID int identity(1,1) primary key, name nvarchar(30) )declare @ID int declare @name nvarchar(30)if exists(select * from T where ID=@ID) begin update T set name=@name where ID=@ID end else begin insert T(name) values(@name) end[/code]
if exists(select语句)//如果记录存在 begin update …… //更新 end else begin insert …… //插入 endGo
drop tb where 主键=@主键
insert tb(主键,...) values(@主键,....)
[code=SQL]create table T(
ID int identity(1,1) primary key,
name nvarchar(30)
)declare @ID int
declare @name nvarchar(30)if exists(select * from T where ID=@ID)
begin
update T set name=@name
where ID=@ID
end
else
begin
insert T(name)
values(@name)
end[/code]
begin
update …… //更新
end
else
begin
insert …… //插入
endGo