vk-kirov (5/27/2010)

---

webrunner (5/27/2010)

---

The invalid object error is in there, but the SELECT statements agree with the SELECT statement results presented in the QOTD correct answer. What statement does the invalid...

Hugo Kornelis (5/27/2010)

---

da-zero (5/27/2010)

---

I do not fully understand.

The batch begins with:

SET IMPLICIT_TRANSACTIONS OFF

According to BOL, this means the following:

... SET IMPLICIT_TRANSACTIONS OFF statement, which returns the connection to autocommit mode....

bkubicek (5/24/2010)

---

Webrunner,

select @startDt = getdate()

select @startDt =

dateadd(millisecond,0-datepart(millisecond,@startDt),

dateadd(second,0-datepart(second,@startDt),

dateadd(minute, 30-datepart(minute,@startDt),

dateadd(hour,10-datepart(hour,@startDt),

@startDt))))

So the idea is that you can start with any date time and set it to a specific time.

If you want the...

Got it right through pure guessing. Perhaps that means, as others have noted, that it was not the best question as far as teaching/learning, due to the complexity of the...

I'd like to second the suggestion to email the whole comment for forum notifications, and also the digest option (daily or weekly or both). As an option, no one would...

Aside from the minor case correction of 'Careful with' that several astute observers noticed, this is a great question. It's even possible it will help in diagnosing something crazy like...

Here are my thoughts on what I'd like to see on SQL Server Central:

1. I agree with a previous post that a "definitive article" section would be great. Or anything...

First, I love your tag line.

Second, I am...

This is the most difficult question I've seen to date, and I've been on SSC a few years now. It's an excellent compilation of information, though, and I will use...

Interesting question, and fascinating discussion. At this point, I'm not sure what the final correct explanation will be.

If it turns out that the error is only in some clients, does...

Great question. I learned that I should read more carefully. This question was about NULLIF (which I had never learned), not ISNULL! :blush:

Thanks,

webrunner

Minor spelling quibble. I believe the spelling is "shear forces," not "sheer forces."

Thanks for the editorial, though - it really got me thinking again about the construction metaphor for software...

Great question. I think the answer choices were suitably plausible, so it made it hard for me to guess. I happened to guess right. 🙂 Seriously, though, this is good...

Good question. The phrasing could have been more precise, such as what does the second 'select @@error' statement return, but I think that is beside the point and should not...

K. Brian Kelley (4/22/2010)

---

It can't be done. Here's why...

If I have admin rights on a server, I have debugging rights. If I have debugging rights, I can see the memory...