Any select could be surrounded by parenthesis:

(select * from sys.objects WHERE name like 'sys%')

(select * from sys.indexes WHERE name like 'c%')

I love a lot the inline TVF.

😛

Stewart "Arturius" Campbell (11/14/2016)

---

Interesting question, thanks Junior.

However, as I am sure you are aware, the sequence is important:

if the query is changed toSELECT 0

UNION

SELECT 1

UNION

SELECT NULL

UNION ALL

SELECT NULL

UNION

SELECT 2;, the...

Steve Jones - SSC Editor (11/3/2016)

---

Clearly I edited an answer somewhere, causing issues. It's certainly my fault. Our interface makes checking these items hard, so I have to be extra...

Despite of the confusion, it's a good question.

You're wrong!

CONCATENATE concatenates only two string. CONCATENATE(<text1>,<text2>)

CONCATENATEX concatenates ALL values of a table. See the...

Very interesting!

Thanks!

Very interesting!

Thanks!

🙂

Rune Bivrin (9/23/2016)

---

Good question, but a small nit-pick:

"The syntax of the batch is correct" is not really an output of the batch, but the conclusion of the parser. That message...

Aaron N. Cutshall (9/22/2016)

---

I got the responses correct except that I also included "Command(s) completed successfully." -- which does flash briefly due to the master table creating successfully (doing them...

When I posted the qotd, all names were lower case. I don't know who capitalized them.

My instance of sqlserver has the binary collation.

Igor Micev (9/21/2016)

---

Carlo Romagnano (9/21/2016)

---

Boh, I don't understand:

The SQL Server 2014 Standard Edition can use up to 16 physical cores. If hyper-threading is enabled on a 16-core server, then there...

Boh, I don't understand:

The SQL Server 2014 Standard Edition can use up to 16 physical cores. If hyper-threading is enabled on a 16-core server, then there are 32 logical processors,...

From BOL:

gareth.davison (9/16/2016)

---

paul.knibbs (9/16/2016)

---

I do wonder why the limit is set at that. Is it just an arbitrary number Microsoft plucked from the air, or is there an actual reason for...