benkoskysa (3/3/2010)

---

With the given SQL, @temp is an empty table, therefore count(1) will always return 0.

benkoskysa (3/3/2010)

---

... I used a database where the sys.master_files table was empty...

Fal (3/3/2010)

---

Well, it can't be empty. At the very least you can expect 8 rows from a brand-spankin' new install, 2 rows for each of master, tempdb, msdb and model. It's likely you don't have the right permissions to this view.

Although, this suggests 2 things: 1) that there is now another reason that people who get a QotD wrong can claim it is invalid - coz the required permissions weren't specified; and 2) that many cut-n-pasters will get the correct answer for the wrong reason.


S.

   select
        top 10
        row_number() over (order by table_name) record_number
        from information_schema.tables

Paul White NZ (3/30/2010)

---

Not my lucky day.

Tom.Thomson (3/31/2010)

---

That sounds as if you got it wrong. I can't resist asking which error did you make:
a) 11 is an even number; or
b) datalength is the same as len
?