(slightly off topic)

You're the second one to post this. I too noticed the END at the end of the script but no BEGIN at...

davoscollective (2/14/2013)

---

I think you've proven how dangerous it is.

The QoTD shows that when using NOT MATCHED that the src.RowNo =1 in the 'on clause' is not evaluated or at...

okbangas (2/14/2013)

---

My explanation might not be 100% accurate, but this is indeed the documentation I found when I ran into the issue demonstrated in the question. That it indeed may...

As Tom said,

However, no one has...

I answered correctly, but for the wrong reason. I'm well aware that when deleting rows SQL Server may internally mark the row as deleted and then come back and clean...

If you ever did need to do this and you are uncomfortable depending on the binary format and the complex SELECT in option 4 scares you (it does me). Here...

As some others have commented, I use it as a quiz and answer based on what I already know without doing any research. Despite that, the main value I get...

As previous posters have commented, the issue is not "because in CASE statements all possibilites are being evaluated" but because the CASE expression must return a single data type so...

For those that are having trouble understanding the "Book[Price < 4 ]" component, here is a bit of an explanation.

If you look at the SELECT statement, you'll notice that there...

I agree that is is a very poor question. I was only arguing that...

A B-tree could only be confused with a binary tree if it is binary with each node having at most 2 children. Wikipedia states this clearly, "a binary tree is...

Questions like this would be unacceptable in the context of a standardized test such as a certification exam. But I think it OK for the QOD because whether you get...

The PIVOT statement can be useful at times, but it is handy to know that anything that can be done with a PIVOT statement can be converted to an equivalent...

Matt Miller (2/14/2008)

---

Except that rule doesn't work in this case:

select getdate() from sys.all_columns

We all know that getdate() is non-deterministic. But still - you will find that you get a...

Matt Miller (2/14/2008)

---

Matt Marston (2/13/2008)

---

-- This will only call the function once

SELECT * FROM sysobjects WHERE [id] <= dbo.fnDateAdd(object_id('dbo.fnDateAdd'))

-- This will call the function for every row in sysobjects.

SELECT...