DugyC (12/12/2012)

---

Knowing already that using sp_rename does not change its definition, and with there being no error scenario in the answers, I had to take the only possibly logical answer...

Great question...but a challenge for a Monday morning!

Yes, there are. That is, there are other inserts and updates that can only occur if there was sufficient funds in the account to cover the transaction.

However, is it not...

Great article! My brain is finally starting to grasp what ROLLUP does.

Great question. Haven't used either the power() function OR the ^ operator in a long time, so a good reminder that there's a lot more to SQL than I get...

Lemmings!

Great question. Missed it, but learned something. Also made me look forward to the upgrade to SQL 2012!

Redeemable!

Vitameatavegamin

(with a nod to...

Oksana March (9/26/2012)

---

DELETE NestleComments FROM NestleComments d

LEFT OUTER JOIN

(SELECT ManagerComment, pk = MIN(PK)

FROM NestleComments

GROUP BY ManagerComment) x

ON d.pk =...

dilly-dally

Divine Flame (9/17/2012)

---

Carlo Romagnano (9/17/2012)

---

You need add the clause "FORMAT" to succeed the second statement!

BACKUP DATABASE TestDatabase_1

TO DISK = 'C:\TestDatabaseBackup.BAK'

WITH COMPRESSION

GO

BACKUP DATABASE TestDatabase_2

...

Thomas Abraham (9/13/2012)

---

Thanks for the question. I got it right, but did so with a semi-educated guess. I reasoned that, if the answer was FALSE, this is a useless question...

Premonition

Thanks for the great question. Together with the link Hugo provided re: data type conversions/precedence, this was a good reminder of what SQL is doing in this type of query.