Which one is a valid create table Sql Statement and why?
Query 1
CREATE TABLE [dbo].[VarArray[]](column int) Go begin tran insert into VarArray(i) select 1 rollback Go while(1=1)]( [column] [int] NULL ) ON [PRIMARY]
Query 2
CREATE TABLE [dbo].[VarArray](column int) Go begin tran insert into VarArray(i) select 1 rollback Go while(1=1)]( [column] [int] NULL ) ON [PRIMARY]
Answers
This was asked a whil back on SqlServerCentral Variable Array Table.
There is a full explanation at Topic.
Why are you asking the question here. Have you even tried running this yourself?