事务日志记录信息2 - 批量插入

SET NOCOUNT ON
GO

INSERT INTO TUsers(FAccount,FLogonPass,FCompanyID,FGradeID,FStatus,FRegisterDate,FLastLogonIP)
SELECT TOP(10) FAccount,FLogonPass,FCompanyID,FGradeID,FStatus,FRegisterDate,FLastLogonIP
FROM dbo.TAccounts WITH(NOLOCK)
WHERE FCompanyID=36052
GO

DBCC LOG(7,1) 
GO

 

SET NOCOUNT ON
GO

BEGIN TRAN
    INSERT INTO TUsers(FAccount,FLogonPass,FCompanyID,FGradeID,FStatus,FRegisterDate,FLastLogonIP)
    SELECT TOP(10) FAccount,FLogonPass,FCompanyID,FGradeID,FStatus,FRegisterDate,FLastLogonIP
    FROM dbo.TAccounts WITH(NOLOCK)
    WHERE FCompanyID=36052
COMMIT TRAN 
GO

DBCC LOG(7,1) 
GO

 

第一个是：INSERT

第二个是：user_transaction

在SQL Server 内部都作为一个批处理。