x5zG2Ewj

1CREATE TABLE dbo.ImportingSystemFileLoadInfo
2(
3    ImportingSystemFileLoadInfoId INT NOT NULL IDENTITY(1, 1) CONSTRAINT PK_ImportingSystemFileLoadInfo PRIMARY KEY CLUSTERED,
4    EnvironmentId INT NOT NULL CONSTRAINT FK_ImportingSystemFileLoadInfo REFERENCES dbo.Environment,
5    ImportingSystemId INT NOT NULL CONSTRAINT FK_ImportingSystemFileLoadInfo_ImportingSystem REFERENCES dbo.ImportingSystem,
6    FileName NVARCHAR(64) NOT NULL,
7FileImportTime DATETIME2 NOT NULL,
8    CONSTRAINT UQ_ImportingSystemImportInfo_EnvXIs_TableName UNIQUE (EnvironmentId, ImportingSystemId, FileName, FileImportTime)
9)
10	
11insert bulk [dbo].[ImportingSystemFileLoadInfo] ([EnvironmentId] Int, [ImportingSystemId] Int, [FileName] NVarChar(64) COLLATE Latin1_General_CI_AS, [FileImportTime] DateTime2(7))
12	
13DROP TABLE IF EXISTS X_TABLE;
14
15CREATE TABLE X_TABLE (
16VAL VARCHAR(1000) NOT NULL
17);
18
19SET STATISTICS IO, TIME ON;
20
21INSERT INTO X_TABLE WITH (TABLOCK)
22SELECT REPLICATE('Z', 1000)
23FROM dbo.GetNums(10000); -- generate 10000 rows