Skip to content

Instantly share code, notes, and snippets.

@jinan-kordab
Created May 28, 2018 01:07
Show Gist options
  • Save jinan-kordab/167484131a9df6ee78889871fd17708b to your computer and use it in GitHub Desktop.
Save jinan-kordab/167484131a9df6ee78889871fd17708b to your computer and use it in GitHub Desktop.
Random data SQL table for Entity Framework and Link To SQL Speed Test
USE [AdventureWorks2012]
GO
/****** Object: Table [dbo].[RANDOMDATA] Script Date: 2018-03-31 01:38:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RANDOMDATA](
[PKID] [int] IDENTITY(1,1) NOT NULL,
[COLUMN1] [varchar](100) NULL,
[COLUMN2] [varchar](100) NULL,
[COLUMN3] [nvarchar](100) NULL,
[COLUMN4] [nvarchar](100) NULL,
[COLUMN5] [nvarchar](100) NULL,
[COLUMN6] [nvarchar](100) NULL,
[COLUMN7] [nvarchar](100) NULL,
[COLUMN8] [nvarchar](100) NULL,
[COLUMN9] [nvarchar](100) NULL,
[COLUMN10] [nvarchar](100) NULL,
[COLUMN11] [nvarchar](100) NULL,
[COLUMN12] [nvarchar](100) NULL,
[COLUMN13] [nvarchar](100) NULL,
[COLUMNN14] [nvarchar](100) NULL,
[COLUMNO15] [nvarchar](100) NULL,
[COLUMNO16] [nvarchar](100) NULL,
[COLUMNO17] [nvarchar](100) NULL,
[COLUMNO18] [nvarchar](100) NULL,
[COLUMNO19] [nvarchar](100) NULL,
[COLUMN20] [nvarchar](100) NULL,
[COLUMN21] [nvarchar](100) NULL,
[COLUMN22] [nvarchar](100) NULL,
[COLUMN23] [nvarchar](100) NULL,
[COLUMN24] [nvarchar](100) NULL,
[COLUMN25] [nvarchar](100) NULL,
[COLUMN26] [nvarchar](100) NULL,
[COLUMN27] [nvarchar](100) NULL,
[COLUMN28] [nvarchar](100) NULL,
[COLUMN29] [nvarchar](100) NULL,
[COLUMN30] [nvarchar](100) NULL,
[COLUMN31] [nvarchar](100) NULL,
[COLUMN32] [nvarchar](100) NULL,
[COLUMN33] [nvarchar](100) NULL,
[COLUMN34] [nvarchar](100) NULL,
[COLUMN35] [nvarchar](100) NULL,
[COLUMN36] [nvarchar](100) NULL,
[COLUMN37] [nvarchar](100) NULL,
[COLUMN38] [nvarchar](100) NULL,
[COLUMN39] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED
(
[PKID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment