Hi,

they are not required to be a string type. But...

Love the question 🙂 Didn't know I was working with a sick whale:

SELECT DIFFERENCE('Sql','sickwhale')

😀

Wow, give me a minute - I need to put this into a pricture frame for my living room (or my next résumé);-)

Hugo Kornelis (6/24/2013)

---

If you are refering to the mistake in the last...

Why was this question reposted with the same misleading explanation as the original QOTD a month ago?

Richard Warr (6/21/2013)

---

Another one where the answer only holds if you have YMD Date Format. Most non-US users will get Error, Error here.

However, it's obvious that the second error is...

Thanks for the question. Please note though that the 2nd query will also fail on some systems with other language settings.

SET DATEFORMAT DMY

GO

--Query 2

DECLARE @dt1 DATETIME

SET @dt1 = '2013-05-30'

SELECT...

Good question, but the answer is wrong.

This is not true. If you change the temporary...

I was also looking for the trick:)

Regarding the aggregates & case evaluation:

the CASE evaluation order is guaranteed for the SELECT phase. I think it helps to understand it when...

Great question. And specifying the IDENTITY_INSERT setting for the table was definitively a good idea. Be explicit.

Be careful with omitting information in your SQL.

For example, it is good practice to explicitly specify the nullability of your columns.

Had ANSI_NULL_DFLT_OFF for the session, the insert would fail.

Msg 515,...

Hi,

There is one subtle issue with the explanation (and also the MS documentation).

It is not the ROLLBACK that is causing the abort of the batch. Instead, the batch is...

As far as I understand, IsNumeric works roughly like this:

CASE WHEN COALESCE(

TRY_CAST(@input AS numeric)

,TRY_CAST(@input AS bigint)

,TRY_CAST(@input AS money)

,TRY_CAST(@input AS smallint)

,TRY_CAST(@input AS smallmoney)

,TRY_CAST(@input AS...

Von Microsoft am 29.12.2009 um 12:11 bereitgestellt

I am resolving the corresonding SQL11 bug as "by design". Here is the explanation: The semicolon between END TRY and BEGIN CATCH should not...

This was the easiest question I have seen in a while!

Why you ask?

Well demonfox gave a nice hint :-):

Note : All queries execute without error, please ignore syntax...