SET ANSI_NULLS ON
\nGO<\/p>\n
SET QUOTED_IDENTIFIER ON
\nGO<\/p>\n
CREATE TABLE [dbo].[COMPANY](
\n[COMPANYID] [int] NOT NULL,
\n[COMPANYNAME] [nvarchar](150) NULL,
\n[COMPANYEMAIL] [nvarchar](150) NULL,
\n[COMPANYSIZE] [nvarchar](150) NULL,
\nCONSTRAINT [PK_COMPANY] PRIMARY KEY CLUSTERED
\n(
\n[COMPANYID] ASC
\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
\n) ON [PRIMARY]<\/p>\n
GO<\/p>\n
<\/p>\n
declare @idx int
\nset @idx = 0<\/p>\n
while(@idx<1000000)
\nBegin
\nINSERT INTO [Enterprise4].[dbo].[COMPANY]
\n([COMPANYID]
\n,[COMPANYNAME]
\n,[COMPANYEMAIL]
\n,[COMPANYSIZE])
\nVALUES
\n(@idx
\n,’company’
\n,’com@email.com’
\n,100000)<\/p>\n
set @idx = @idx +1<\/p>\n
end<\/p>\n
GO<\/p>\n","protected":false},"excerpt":{"rendered":"