Thanks Steve for this interesting question and cleverly constructed combination of the answers... 😉

+1

Thanks Henrico for this question.:-)

James Lean (10/20/2016)

---

The answer is not quite correct. As written, it will run successfully but will not actually drop the trigger.

For logon triggers you need to use:

DROP TRIGGER IF...

+1 😉

Yes, easy one. Thanks Steve for this question.

I had a lot of search in my memory about working with xml documents.:satisfied:

Thanks Steve for this question good explanation and useful links. The series "Stairway to XML" by Robert...

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