1.
if exists(select Uid from tableA where Uid=@Uid)
update tableA
set field1=@vF1,
field2=@vF2,
...
where Uid=@Uid
else
insert tableA(Uid,field1,field2,...)
values(@Uid,@vF1,@vF2,...)
2.--当下次更新不需要考虑上次同条记录的其他字段值时(除UID字段外其他皆可覆盖)
delete tableA where Uid=@Uid
insert tableA(Uid,field1,field2,...)
values(@Uid,@vF1,@vF2,...)