Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 2,393, Visits: 2,286
Comments posted to this topic are about the item Unary & Aliases
Post #1173879
Posted Tuesday, September 13, 2011 12:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 12,206, Visits: 9,169
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 LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1173908
Posted Tuesday, September 13, 2011 1:16 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, February 05, 2014 6:49 AM
Points: 861, Visits: 793
Thank you for the question,

regards,
Iulian
Post #1173920
Posted Tuesday, September 13, 2011 2:02 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, April 14, 2014 5:40 AM
Points: 422, Visits: 145
Thanks for the question.

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


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: Yesterday @ 6:40 AM
Points: 3,683, Visits: 4,818
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, April 09, 2014 10:36 AM
Points: 896, Visits: 1,479
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
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, February 06, 2014 4:15 AM
Points: 1,242, Visits: 1,546
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:35 AM
Points: 1,625, Visits: 2,034
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: Wednesday, October 24, 2012 8:17 PM
Points: 1,588, Visits: 247
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