I'm inclined to agree with you, but I asked the question because ARRAY is in the ANSI SQL standard.
The following quote comes from SQL:1999 , formerly known as SQL3...

Will ARRAY ever be added to T-SQL?
Who would like to see it added?

Terje Hermanseter (6/3/2016)

---

Too much old...

Anyone who doesn't terminate SQL statements with a semicolon should note the following (from https://msdn.microsoft.com/en-us/library/ms177563%28v=sql.110%29.aspx ):

Transact-SQL statement terminator.Although the semicolon is not required for most statements in this version of...

Yes, "really dangerous".

I can't imagine any situation where it would be good practice to do this (although I understand how it could be tempting).

Does anyone have an example of where...

Looks like a third of people should have stayed in bed with the covers over their heads rather than answer this question... :w00t:

Had to think hard about that one ...

According to Chambers Dictionary, the definition of "wrong" includes:

"not appropriate or suitable"

"not good or sensible; unjustifiable"

"amiss, causing trouble, pain, etc"

"not socially acceptable"

I think you could make a case for the...

Of course, if you have more than 2^21 columns in your database, it will return an error ... 😀

What version of SQL Server Management Studio are you using, Daleen?

Inserting multiple value lists is only possible from SQL Server 2008 onwards, so if you are running SQL Server 2005...

For amusement, you could try the following:

select convert(smalldatetime,'9-2014-1',110)

This returns 1st Sept 2014.

It appears that it doesn't matter where in the string you put the year!

pmadhavapeddi22 (5/7/2014)

---

As per my observation, below mentioned code returns error ,

DECLARE @int AS INT = @b1 + @b2;

SELECT @b1 + @b2;

but, following code returns 5

DECLARE @b1...

Is a "tiny bit" a "bit" that will only store zeroes? 😀

My personal feeling is that "bit" is not an...

Koen Verbeeck (2/11/2014)

---

ashwani24 (2/10/2014)

---

Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any...

Here in the north...