if exists(select 1 from [table] where [user_id]=9999)
update..
else
insert..
或:update [table] set..... where [user_id]=9999if @@rowcount=0
insert...
update..
else
insert..
或:update [table] set..... where [user_id]=9999if @@rowcount=0
insert...
update [table] set..... where [user_id]=9999if @@rowcount=0
insert...
update 表 set ... where user_id=9999
if @@rowcount=0 --如果更新记录为0条,则说明不存在,执行插入
insert into 表() values()
insert...
”
HEI,HEI!!
又学了一招!!!
UP,UP,UP!!!
if exists(select 1 from tablename where id=9999)
update tablename set ......
else
insert tablename ......
end