Lynn Pettis (3/7/2008)

---

Since all provided answers were actually wrong (even though #2 seemed to provide a more accurate answer than #1 or #3), noone should lose any points for attempting...

I'd rather say that noone who...

Colin Davidson (3/7/2008)

---

Yes The 1 and the 0 are definitely the wrong way round, leap year's are a problem, but try using cast(DateDiff("d", DateOfBirth, getdate()) / 365.25 as tinyint) which...

I did not answer today's question since none of the answers is correct.

First, none of the answers returns a tinyint. One returns decimal(9,2), the others return int

Second, they all produce...

True. And I...

The actual problem is that a view is conceptuallly equal to a table - that is, it has no implied sort order. The only way to be sure to get...

Hi Steve,

I see that you have beaten me to the punch. That's the down side of having something else as your day job 🙂

Anyway, I still have decided to blog...

Hi Chad,

I'll just chime in here and say that I like the question very much. The only thing that could have imoproved it was if there had been an explicit...

Hi D,

The relevant quote on the referenced page is: "It may be applied anywhere a table or table expression is used...

As an FYI, allow me to add that, even though the question speicfically mentions SQL Server 2000, the maximum size for context session information is actually the same in SQL...

Steve Jones - Editor (1/16/2008)

---

Sorry, the initial documentation said data center only, but since the question was written (a few months ago), it's changed. Or been updated.

Points awarded back and...

A bit more thought should have gone in this question (and the answers) before posting them.

The documentation says that this feature "Requires the 64-bit edition of Windows Server 2008 Datacenter...

Hi Jeff,

Well, that really depends on how you define "it works" for sp_depends.

The most simple explanation I can give for sp_depends in that it basically has the same effect as...

Hi Jeff,

The schema change in the discussion so far was actually meant to relate to a change in the schema (i.e. design) of the table, not to a change in...

Hi Jeff,

I don't know what you did to try this. The code below works for me. Can you post the code you used to test...