r2uGvLjs

1USE [ArticleCloud];
2BEGIN TRANSACTION;
3SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
4SET XACT_ABORT ON;
5CREATE TABLE [dbo].[tmp_ms_xx_Tables] (
6                                          [TableId]       INT          IDENTITY (1, 1) NOT NULL,
7                                          [TableScreenId] INT          NULL,
8                                          [TableName]     VARCHAR (50) NOT NULL,
9                                          [AffiliateId]   INT          NOT NULL,
10                                          [Capacity]      INT          NULL,
11                                          [CustomTableNumber] INT      NULL,
12                                          CONSTRAINT [tmp_ms_xx_constraint_PK_Tables1] PRIMARY KEY CLUSTERED ([TableId] ASC)
13);
14
15IF EXISTS (SELECT TOP 1 1
16           FROM   [dbo].[Tables])
17    BEGIN
18        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_Tables] ON;
19        INSERT INTO [dbo].[tmp_ms_xx_Tables] ([TableId], [TableScreenId], [TableName], [AffiliateId], [Capacity], [CustomTableNumber])
20        SELECT   [TableId],
21                 [TableScreenId],
22                 [TableName],
23                 [AffiliateId],
24                 [Capacity],
25                 [CustomTableNumber]
26        FROM     [dbo].[Tables]
27        ORDER BY [TableId] ASC;
28        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_Tables] OFF;
29    END
30
31DROP TABLE [dbo].[Tables];
32EXECUTE sp_rename N'[dbo].[tmp_ms_xx_Tables]', N'Tables';
33EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_Tables1]', N'PK_Tables', N'OBJECT';
34COMMIT TRANSACTION;
35SET TRANSACTION ISOLATION LEVEL READ COMMITTED;