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?


Need Your Help

Should I use “self” to define variables / objects of class instanced which I will not need to reach from the outside?

python oop python-2.7 python-2.x

I am not a complete beginner but fairly new to Python. Whilst working on a project today I just had an idea and wondered regarding the usage of "self"; about which I've been reading for the past some

Read XML on client side of ASP.NET MVC 4 website

jquery xml asp.net-mvc client-side

I am working on a ASP.NET website and I need to get XML from an external url. It works great using ASP.NET MVC's XmlDocument but now I need to parse the XML without going to the server again, so

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.