USE AdventureWorks

GO

-- 복구모델Simple겠죠?

-- 검사쿼리

select operation,context, [log record fixed length], [log record length], AllocUnitId, AllocUnitName

from fn_dblog(null, null)

where allocunitname='dbo.t1'

order by [Log Record Length] Desc

-- 원본테이블

SELECT * FROM Person.Address

-- 1.힙테이블+ select into

-- 있으면삭제

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[t1]') AND type in (N'U'))

DROP TABLE [dbo].[t1]

GO

SELECT * INTO t1 FROM Person.Address

-- 19614 행입력

-- 검사쿼리

select operation,context, [log record fixed length], [log record length], AllocUnitId, AllocUnitName

from fn_dblog(null, null)

where allocunitname='dbo.t1'

order by [Log Record Length] Desc

-- 487 Rows 기록

-- 2.힙테이블+ insert into

-- 있으면삭제

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[t1]') AND type in (N'U'))

DROP TABLE [dbo].[t1]

GO

CREATE TABLE [dbo].[t1](

             [AddressID] [int] NOT NULL,

             [AddressLine1] [nvarchar](60) NOT NULL,

             [AddressLine2] [nvarchar](60) NULL,

             [City] [nvarchar](30) NOT NULL,

             [StateProvinceID] [int] NOT NULL,

             [PostalCode] [nvarchar](15) NOT NULL,

             [rowguid] [uniqueidentifier] NOT NULL,

             [ModifiedDate] [datetime] NOT NULL

) ON [PRIMARY]

GO

INSERT INTO t1 with (tablock)

SELECT * FROM Person.Address

-- 19614 행입력

-- 검사쿼리

select operation,context, [log record fixed length], [log record length], AllocUnitId, AllocUnitName

from fn_dblog(null, null)

where allocunitname='dbo.t1'

order by [Log Record Length] Desc

-- 487 Rows 기록