sql 事务

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROCEDURE [dbo].[Adsense_Add]
    @adsnesefiled varchar(500),
    @adsensevalue varchar(2000),
    @accountfiled varchar(200),
    @accountvalue varchar(1000)

AS
BEGIN
    declare @count int
    set @count = 0
    begin tran
    exec ('insert into adsense('+@adsnesefiled+') values('+@adsensevalue+')')
    set @count = @count + @@error
   
    exec ('insert into account('+@accountfiled+') values('+@accountvalue+')')
   
    set @count = @count + @@error
    if @count > 0
    begin
        rollback tran
    end
    else
    begin
        commit tran
    end   
END