T-SQL Logic

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Henrico Bekker » T-SQL Logic

23 posts, Page 1 of 3

1 2 3 »»»

T-SQL Logic

Rate Topic

Display Mode

Topic Options

Author

Message

Henrico Bekker

Posted Monday, June 21, 2010 8:17 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

Comments posted to this topic are about the item T-SQL Logic

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #940724

sharath.chalamgari

Posted Tuesday, June 22, 2010 12:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038, Visits: 679

simple one, just need to analyse the Query.

Post #940769

Hugo Kornelis

Posted Tuesday, June 22, 2010 2:04 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:51 AM
Points: 5,232, Visits: 7,023

I hope it is not considered cheating that I did run

SELECT database_id, name FROM sys.databases ORDER BY 1;

before answering. I don't thik there is any need for me to know ids of system databases by head.

Other than that, the question was a bit too simple. Just the AND database_id < 2 was sufficient to determine that there would be one result, and there was only one option with one result, so there was no need at all to evaluate the CASE and POWER expressions.

Anyway, thanks for the question Henrico! Your first, I believe? Hopefully there will be more in the future!

Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Post #940812

ziangij

Posted Tuesday, June 22, 2010 2:23 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:53 AM
Points: 1,526, Visits: 359

and database_id < 2

this was enough to answer the question... Smile

Post #940822

Henrico Bekker

Posted Tuesday, June 22, 2010 2:48 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

Hi Hugo, yes, looking at the last where statement, it was easy to determine the answer.
But, look at the wrong answer rate - 19 so far.

This question was purely to test logic when it comes to reading code, and was not intended to be a massive brain cracker BigGrin

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #940832

Toreador

Posted Tuesday, June 22, 2010 3:43 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:52 AM
Points: 1,356, Visits: 4,761

I just used the len(case...) statement - since this can return only one row (master) then the answer is the one with only a single option.

Post #940871

john.allan-931338

Posted Tuesday, June 22, 2010 3:44 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 24, 2012 4:01 AM
Points: 318, Visits: 154

It would have been more interesting if it had read "and database_id <= 2
" which would have brought the case statement into play more.

That's the way I read it anyway. Good thing it had the same answer Smile

Post #940872

Danny Ocean

Posted Tuesday, June 22, 2010 6:09 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:46 AM
Points: 1,074, Visits: 1,130

Another easy point Smile

Keep Learning - Keep Growing !!!
http://growwithsql.blogspot.in

Thanks
Vinay Kumar

Post #940966

webrunner

Posted Tuesday, June 22, 2010 8:04 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:05 PM
Points: 2,117, Visits: 2,209

I got this right! I learned my lesson from the last time - after equivocating for a minute, wondering "the choice of 1 is too easy, maybe there's a trick" - I decided that no trick was evident based on the code.

Simple question for many at SSC, I suppose. But still worth looking at and being able to explain for "lesser experts" (i.e., those of us who get too many QOTD questions wrong Smile

)

- webrunner

-------------------
"The chemistry must be respected." - Walter White

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Post #941065

OCTom

Posted Tuesday, June 22, 2010 8:06 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:42 PM
Points: 2,012, Visits: 2,839

And the point is?... lost on me... again. w00t

Post #941067

« Prev Topic | Next Topic »

23 posts, Page 1 of 3

1 2 3 »»»

Permissions