1、update ... if @@rowcount=0 insert into 2、delete from 3、if exists(select * from ) update .. else insert into