SQL Server transaction+在sql执行中进行条件判断

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语句