<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Sunil Chandurkar
»
DATETIME Puzzle
33 posts, Page 2 of 4
««
1
2
3
4
»
»»
DATETIME Puzzle
Rate Topic
Display Mode
Topic Options
Author
Message
tabinsc
tabinsc
Posted Thursday, November 17, 2011 7:16 AM
Old Hand
Group: General Forum Members
Last Login: Today @ 2:46 PM
Points: 372,
Visits: 419
I didn't see anything as to what question we were supposed to answer. Luckily I guessed correctly that we were supposed to select how many rows were returned by the query.
Tony
------------------------------------
Are you suggesting coconuts migrate?
Post #1207498
vk-kirov
vk-kirov
Posted Thursday, November 17, 2011 7:50 AM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, June 13, 2013 8:50 PM
Points: 3,208,
Visits: 4,178
tabinsc (11/17/2011)
I didn't see anything as to what question we were supposed to answer. Luckily I guessed correctly that we were supposed to select how many rows were returned by the query.
The question is written in large letters, although with a typo ("may" instead of "many")
How may rows will be returned by following query?
Post #1207532
Toreador
Toreador
Posted Thursday, November 17, 2011 8:11 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 10:02 AM
Points: 1,383,
Visits: 4,870
A very easy question, unless you temporarily forget how to count
Post #1207554
Daniel Bowlin
Daniel Bowlin
Posted Thursday, November 17, 2011 8:13 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 2,681,
Visits: 2,423
Good question, thanks.
Post #1207557
Ola L Martins-329921
Ola L Martins-329921
Posted Thursday, November 17, 2011 8:22 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, June 10, 2013 3:11 AM
Points: 264,
Visits: 179
sknox (11/17/2011)
I've seen this crop up enough time on the forums to see why it rates 2 points.
While the answer is super-easy if you know DATETIME, this question highlights one of the easiest mistakes for a beginner to make, and one that has serious real-world implications.
Hear! Hear!
Post #1207574
Revenant
Revenant
Posted Thursday, November 17, 2011 9:14 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 5:32 PM
Points: 3,508,
Visits: 2,588
THis was a really simple one - thanks!
Post #1207618
rfr.ferrari
rfr.ferrari
Posted Thursday, November 17, 2011 9:20 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, June 06, 2013 4:06 PM
Points: 1,219,
Visits: 13,509
good question!!!
rfr.ferrari
DBA
- SQL Server
2008
MCITP | MCTS
remember is live or suffer twice!
Post #1207624
OzYbOi d(-_-)b
OzYbOi d(-_-)b
Posted Thursday, November 17, 2011 9:58 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176,
Visits: 778
nice easy question today - tks
Post #1207683
GPO
GPO
Posted Thursday, November 17, 2011 10:56 AM
Say Hey Kid
Group: General Forum Members
Last Login: Today @ 8:06 PM
Points: 664,
Visits: 1,337
There are good reasons to avoid using BETWEEN when comparing two datetimes. Particularly in the example the answer uses. You should be using the various symbols for GREATER THAN and LESS THAN.
One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important.
Bertrand Russell
Post #1207757
Ola L Martins-329921
Ola L Martins-329921
Posted Thursday, November 17, 2011 12:49 PM
SSC Veteran
Group: General Forum Members
Last Login: Monday, June 10, 2013 3:11 AM
Points: 264,
Visits: 179
GPO (11/17/2011)
There are good reasons to avoid using BETWEEN when comparing two datetimes. Particularly in the example the answer uses. You should be using the various symbols for GREATER THAN and LESS THAN.
No, I don't think you can (if not reverting to subqueries...)
The "AND" operator will check against the date-columns seperately - not simultaneously which in the case with "BETWEEN".
Using GREATER THAN and LESS THAN in the above question would actually return all the records.
(Sorry, being a bit rusty I'm not entirely sure this is correct, but I've been there, done that and bought the friggin' t-shirt...)
Post #1207840
« Prev Topic
|
Next Topic »
33 posts, Page 2 of 4
««
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
