Right, but my point...

James Goodwin (5/20/2008)

---

I think everyone is missing the point of what is happening.

What is occuring is an automatic type conversion. If I do this:

Declare @tmp datetime

set @tmp = '20080101'

select...

bitbucket (5/20/2008)

---

As the author of this QOD, and a SQL developer NOT a DBA, I would like to thank all who entered this discussion. I think the question developed...

SQL may be correct in...

Carla Wilson (5/20/2008)

---

What this question highlights is that an error is NOT thrown when you pass a parameter value that is too long into the function.

If you tried that with...

ezlikesundaymorning (5/14/2008)

---

Excellent. I guess that I can just sit here and bitch or start contributing myself when it all boils down to it. Thanks for the reply. I am just...

ezlikesundaymorning (5/14/2008)

---

OK, just plain and simple, I am going to give my 2 cents worth here. This question is pure BS. I mean has anyone here ever seen a query...

I got the question wrong, which is OK, but I think choices such as "Query is wrong" sound too vague. Perhaps "Query throws an error" or the specific error or...

I'd love to write more about SQL (or some other nonfiction categories, too) but I don't have anywhere near the talent or experience needed to write something new or authoritative....

Yes, it does.

Also, and this...

I agree. I think this is a great question. I got it wrong, but it showed me I still have more to learn about NULLs.

Thanks,

webrunner

WayneS (5/2/2008)

---

Since the question clearly states:

use could use:

where DatePart(m, ) IN (1,3,4,5,7,8)

OR is not used, so since they BOTH...

Steve Jones - Editor (4/30/2008)

---

The half.com idea doesn't really suit me as I won't sell them back. The 1/2 price doesn't really make a difference to me and it's a...

Hi Steve,

I have the Sony Reader. The controls take a little getting used to, but the type is very readable and you can pick from 3 different type sizes.

The...

[font="Courier New"]select floor(13.890)[/font] returns [font="Courier New"]13[/font], but just for fun, here are the results for a couple of variations in SQL 2000 (one difference from SQL 2005 is shown):

[font="Courier New"]select...