begin transaction
declare @parameter type
select @parameter = count(*) from table_name where A = ' '
if @parameter1 <> 0
begin
执行sql
end
else
begin
执行sql
end
commit transaction
例:
begin transaction
declare @isExit int
select @isExit = count(*) from person where userId = ' 10086'
if @isExit <> 0
begin
update person set lastUpdateDate = getdate()
end
else
begin
insert into person ( userId, lastUpdateDate ) values ('10086', getdate() )
end
commit transaction
查询person表中是否存在userId为‘10086’的记录,如果存在,执行update语句,否则,执行insert语句