I replied wrong - I saw the rollback after the truncate, assumed the question intended to test my understanding that a truncate can be rolled back, and then replied. I...

john.moreno (1/3/2011)

---

Which is a...

Don Avery (1/3/2011)

---

Actually, I'm right - this query will return 0 rows for both SELECT statements as it will never run - you cannot insert into a table with and...

Great question!

I see so many people posting to forums or newsgroups, asking why they can't use IN (@variable) in this way with a comma-delimited list in the variable, that it's...

Nice question. Though I'm surprised at the high percentage of incorrect answers.

Also, the disclaimer can be removed. This behaviour of the UPDATE statement is how the ANSI standard prescribes it...

deeptidas23 (12/30/2010)

---

when we run it on sql server only one record is getting stored in table becoz of check constraint.how come only 3 records??Can anyone explain me after executing in...

Good (if fairly easy) question, but bad explanation.

The default for smalldatetime is not Jan 1, 1900; it is NULL. Here is the proof:

DECLARE @d1 smalldatetime;

SELECT @d1;

Also, setting a variable to...

dbuendiab (12/23/2010)

---

I'm sorry for your lost points, guys. If it's a consolation for you, I spent two mornings completely puzzled with this issue, to the point I asked for help...

I got the question right, assuming that the submitter was unaware of the fact that there is no guarantee for this behaviour. I was then surprised to see in the...

This was an ... interesting question.

I don't call it a good question, because of the complexity - not the complexity of the subject matter, but that of the number of...

Tom, thanks for your comment. I mostly agree with what you say.

This was one of my first questions here, and not one I am still very proud of. The idea...

Because incomplete data is a fact of life.

Companies that only do business when all data their database has...

mtillman-921105 (12/15/2010)

---

Mike Dougherty-384281 (12/14/2010)

---

In the case of "Null value is eliminated by an aggregate or...

Luckily, you can enable trace flags without restarting...

CavyPrincess (12/10/2010)

---

My opinion - what needs to be "fixed" is the default option of FULL on model. There are a lot of non-DBAs supporting SQL Server. Databases are...