Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Unary & Aliases Expand / Collapse
Author
Message
Posted Monday, September 12, 2011 9:45 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 28, 2016 1:13 AM
Points: 3,367, Visits: 3,190
Comments posted to this topic are about the item Unary & Aliases
Post #1173879
Posted Tuesday, September 13, 2011 12:23 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 6:23 AM
Points: 15,499, Visits: 13,162
Pretty easy question, if you eliminate incorrect answers.
@b is never used, so the first and the last answer were impossible.
I knew there wasn't any incorrect syntax with the aliases, so the second answer was also incorrect. So that leaves us only with the arrays of numbers.
However, as the B column always returns 1, it was pretty easy to deduce the correct answer.

Nonetheless, great question which incorporated various scenarios. Thanks.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1173908
Posted Tuesday, September 13, 2011 1:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 17, 2016 10:08 AM
Points: 1,142, Visits: 1,220
Thank you for the question,

regards,
Iulian
Post #1173920
Posted Tuesday, September 13, 2011 2:02 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, March 2, 2016 3:02 AM
Points: 561, Visits: 179
Thanks for the question.

:)
Post #1173938
Posted Tuesday, September 13, 2011 2:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, December 1, 2016 9:44 PM
Points: 5,356, Visits: 7,064
Interesting question
Thanks


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1173947
Posted Tuesday, September 13, 2011 2:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 8:16 AM
Points: 161, Visits: 142
Thanks for the question.
I got it wrong, and learned something!
Post #1173956
Posted Tuesday, September 13, 2011 5:02 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, March 2, 2016 5:17 AM
Points: 955, Visits: 1,514
Thank you for the question.
Had to think this one through because of the operators.
And the variable was just to mess with us?

Best regards,



Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA
Post #1174000
Posted Tuesday, September 13, 2011 5:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 23, 2015 2:40 AM
Points: 1,242, Visits: 1,549
Nice question, But i got it wrong.



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1174005
Posted Tuesday, September 13, 2011 5:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, May 31, 2016 4:13 PM
Points: 2,107, Visits: 2,254
Nice question Carlo! My first thought was, "What am I supposed to learn from this question?" Then I dug in a little deeper. Got it right, but not as quickly as I might have. I still haven't learned to read the title for help.

I still have the "Look at the shiny object ..." reaction when I follow the link to the question.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1174024
Posted Tuesday, September 13, 2011 5:45 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Good question. I admit I had to run it to get the correct answer. Just couldn't visaulize it in my head.

http://brittcluff.blogspot.com/
Post #1174039
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse