GP Van Eron (10/10/2016)

---

Thank you for the feedback. If I wrote the question again I would focus a bit more on learning SERVERPROPERTY options rather than nuisances...

Quite an interesting question for practical use, thanks to GP Van Eron. 🙂

I understand that if on SQL Server 2012 was the last installation

Cumulative Update #14 for SQL Server...

Rune Bivrin (10/7/2016)

---

Nice'n'easy!

Funny part in the docs:

How do I...

Budd (10/5/2016)

---

Very interesting.

A little additional research shows that the 3rd parameter can be anything other than the default of zero will cause the round function to truncate at the location...

Thanks Steve. It's a practical one from the category cute quickies QotD.;-)

+1 🙂

Nice explanation the OUTPUT clause is in: https://www.simple-talk.com/sql/learn-sql-server/implementing-the-output-clause-in-sql-server-2008/

George Vobr (9/29/2016)

---

colin.frame (9/29/2016)

---

Thanks George. That triggered a further bit of research.

The puzzle for me was where the extra decimal places came from in the AVG result....

colin.frame (9/29/2016)

---

Thanks George. That triggered a further bit of research.

The puzzle for me was where the extra decimal places came from in the AVG result. I've...

colin.frame (9/29/2016)

---

Why do we get an answer like "9.000000" instead of "9" when the length is 0 (i.e. rounded to no decimal points)? The answer here has two parts....

As the output a message of the parser in the query result window? :unsure:

(a small nit-pick...) 😉

An interesting QotD, but it was necessary to proceed slowly and cautiously to find the right answers...:hehe:

Thanks Carlo for thoughtfully prepared question and good references.

Thanks Igor for this question. It made me diligently googled and study

SQL Server Hardware e-book from Glenn Bery and more. Then I found the correct

answer in an article on...

Formulation of the question makes me a bit confused. Which transaction isolation level is NOT available to transactions running

in the master and msdb databases? For the DB administrator, all...

Practical for use is that the second parameter may have also a negative value,

thanks for this seemingly simple question Nagaraj. 🙂

Interesting question and even more interesting answer, thanks Steve 🙂

The answer "The row is not updated and no error is returned."

should rather be listed as: "No row is not...