Nice question, thanx, knew the answer but was not sure, so made some R&D on it.

+1

Definitly learned somthing new today, thanks for the question.

Yeah, I remember once upon a time a tested piece of code (turned out...

pmadhavapeddi22 (2/11/2015)

---

I have checked the rows in sys.syscacheobjects before/after running the selects, found 5 new rows with all the selects mentioned in QOD.

select * from sys.syscacheobjects where objtype ='adhoc' and...

+1

sestell1 (2/9/2015)

---

This comes in quite handy if you want to grant access to a stored procedure that requires some elevated permissions to run, but you don't want to grant those...

On the contrary 4 me, I knew this one as I...

Congratulations 😀

Gr8 question, thanx.

Maybe tomorrow QoTD will be:

COUNT(*) AS MyCount

And MyCount value will be 2 in this case (*) for the Null rows 😛

Interesting, thanx.

Never used Some fn b4, thanx for sharing the question & info 🙂

Thanx, learned somthin new 2day.

Hugo Kornelis (1/22/2015)

---

Too bad the explanation claims that NULL values are considered with * is used. Using * makes COUNT use rows, not values, and rows cannot be NULL.

Other then...