IF NOT EXIST(SELECT * FROM Card) INSERT Card('id','name') VALUES(1,'MIKEJ') ELSE UPDATE Card SET Name = 'mikej'
yannankai兄,你的条件反了:)
搞定,设置了个变量 谢谢了。declare @count as int begin select @count=count(*) from createdcard if @count=0 insert createdcard (id,sremoved,success) values(1,0,1) else update createdcard set id=2 end
INSERT Card('id','name') VALUES(1,'MIKEJ')
ELSE
UPDATE Card SET Name = 'mikej'
begin
select @count=count(*) from createdcard
if @count=0
insert createdcard (id,sremoved,success) values(1,0,1)
else
update createdcard set id=2
end