Very nice question. The escape sequence for that ODBC date was new to me.

I thought everyone I work with only used 4 digit years until last week. I saw some code where they were using test values for date parameters with 2 digit...

Nice question. I didn't know about the cutoff year either.

L' Eomot Inversé (3/6/2013)

---

KWymore (3/6/2013)

---

That will return Is Numeric as well. Same thing if you do '£NAME'. I think any...

bitbucket-25253 (3/6/2013)

---

Agree with the title of the QOD being missleading, and to make sure people do NOT conclude, incorrectly, how ISNUMERIC works may I suggest that every one read...

That will return Is Numeric as well. Same thing if you do '£NAME'. I think any currency character will evaluate...

Nice question and great explanation. Thanks!

I totally overlooked the misspelled WITH too. I never knew you could use a hint without using WITH. Interesting question. Thanks Serge!

Thanks for the 2012 question.

Thanks for the easy question!

Nice question Lokesh. I never would have thought to try changing the database through and execute statement. Now I know what would happen had I tried!

We have used cross joins for things like this as well. We used to do sign-off sheets at the end of payroll cycles so managers could have their employees sign...

Hugo Kornelis (2/13/2013)

---

I had almost missed the different time in the returned output, as I was focusing completely on the data type. Caught is just in time!

I do not agree...

I made the assumption that the author didn't actually understand that GO was a batch separator and was instead focused on the temp table creation process. I hate to make...

L' Eomot Inversé (2/7/2013)

---

Wow, that is a humorous thread! I am glad I don't work with that lead. Talk about misdirection...