PRINT N'Starting rebuilding table [dbo].[Product]...';
GO
BEGIN TRANSACTION;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET XACT_ABORT ON;
CREATE TABLE [dbo].[tmp_ms_xx_Product] (
[ProductId] INT NOT NULL,
[ProductName] NVARCHAR ( 30) NOT NULL,
[Category] NVARCHAR ( 30) NULL,
CONSTRAINT [tmp_ms_xx_constraint_PK_dboProduct] PRIMARY KEY
CLUSTERED ([ProductId] ASC)
);
IF EXISTS (SELECT TOP 1 1
FROM [dbo].[Product])
BEGIN
INSERT INTO [dbo].[tmp_ms_xx_Product] ([ProductId], [ProductName])
COMMIT TRANSACTION;
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
GO
PRINT N'Update complete.'
GO
www.sqlmag.com
sql server Pro / may 2013
