if exists(select id from t where id=1) begin update...... end else begin insert...... end
update tablename set ... where id=1 if @@rowcount=0 insert tablename (id) values (1) ------------------------------- if exists(select id from t where id=1) begin update...... end else begin insert...... end ----------------------------- 這兩個都可以;不過上邊的比較少見
begin
update......
end
else
begin
insert......
end
if @@rowcount=0
insert tablename (id) values (1)
-------------------------------
if exists(select id from t where id=1)
begin
update......
end
else
begin
insert......
end
-----------------------------
這兩個都可以;不過上邊的比較少見