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...

The correct answer is "Depends", if the view returns or not a row:

No row returned: -> The row is not updated and no error is returned.

Row returned: -> No update...

That's true!

SELECT ROUND(0.7 , 0) as a into #a

Here, the table created:

CREATE TABLE dbo.#a1

(

a numeric(1,1) NOT NULL

)

Interesting, thanks!

But, how do I convert it in previous release of sqlserver?