SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Carlo Romagnano / Unary & Aliases / Latest Posts

RE: Unary & Aliases

zymos — Fri, 02 Mar 2012 15:06:02 GMT

Interesting question and took quite sometime to figure out and also learnt along the way.Thank you.

RE: Unary & Aliases

Olga B — Wed, 14 Sep 2011 12:36:23 GMT

Carlo - absolutely that is confusing. When I [i]intend[/i] to alias the column, I prefer to use [ColumnName] = col1 syntax, which aligns all my column names nicely. The problem arises when I lose the comma by accident, and SQL turns col2 into an alias for col1, thus messing up my output.

RE: Unary & Aliases

Carlo Romagnano — Wed, 14 Sep 2011 01:56:57 GMT

[quote][b]Olga B (9/13/2011)[/b][hr]Ah yes, my "favorite" bit of SQL syntax [code="sql"]select 0 [A][/code]A fun bug to find when I accidentally delete a comma and then try to figure out what's wrong with the output of[code="sql"]select col1 col2, col1003from sometable[/code]What? I can't be the only one!:ermm:Thanks for the question![/quote]My favorite syntax is [code="sql"]select col1 AS [newcolname/sometime user friendly col name]from sometable[/code]Other syntax is less readable and as you wrote it may lead to unwanted bug. But maybe very usefull for code generators.

RE: Unary & Aliases

Carlo Romagnano — Wed, 14 Sep 2011 01:41:05 GMT

[quote][b]Tom.Thomson (9/13/2011)[/b][hr]Amusing and fairly easy question.The misprints in the explanation may have left some people confused. All three alias forms are wrong (1st missing "= <", second and third bpth missing "alias").edit: I can make typos too. Fixed.[/quote]Unfortunately, the editor to contribute with a question, sometime, changes the text both in the question and more often in the explanation. The explanation was victim of this change. I think because of GREAT and LESS sign that are misinterpreted as html syntax.

RE: Unary & Aliases

matt.bowler — Tue, 13 Sep 2011 16:45:27 GMT

Good puzzler - thanks. Nice coverage of different scenarios.

RE: Unary & Aliases

L' Eomot Inversé — Tue, 13 Sep 2011 16:30:31 GMT

Amusing and fairly easy question.The misprints in the explanation may have left some people confused. All three alias forms are wrong (1st missing "= <", second and third bpth missing "alias").edit: I can make typos too. Fixed.

RE: Unary & Aliases

Olga B — Tue, 13 Sep 2011 16:02:41 GMT

Ah yes, my "favorite" bit of SQL syntax [code="sql"]select 0 [A][/code]A fun bug to find when I accidentally delete a comma and then try to figure out what's wrong with the output of[code="sql"]select col1 col2, col1003from sometable[/code]What? I can't be the only one!:ermm:Thanks for the question!

RE: Unary & Aliases

CoolCodeShare — Tue, 13 Sep 2011 14:56:05 GMT

It's a nice and interesting question. Thanks.

RE: Unary & Aliases

SQLRNNR — Tue, 13 Sep 2011 13:21:01 GMT

Nice question.

RE: Unary & Aliases

Artur Komkov — Tue, 13 Sep 2011 13:00:46 GMT

My first opinion was: very exotic question far away from practical usage.But later I changed my minds. Never thought about arithmetical operations in T-SQl work in such way. Thanks a lot.

RE: Unary & Aliases

charles evans — Tue, 13 Sep 2011 11:40:34 GMT

I think I may need eye glasses, I really had to look hard at the commas to differentiate them from periods... I almost chose the Incorrect Syntax error.

RE: Unary & Aliases

Revenant — Tue, 13 Sep 2011 08:36:38 GMT

Excellent question - thank you!

RE: Unary & Aliases

KWymore — Tue, 13 Sep 2011 08:09:11 GMT

Interesting stuff. Thanks for the question.

RE: Unary & Aliases

rfr.ferrari — Tue, 13 Sep 2011 06:36:58 GMT

good and easy question!

RE: Unary & Aliases

Ernie Schlangen — Tue, 13 Sep 2011 06:07:33 GMT

Thanks for an interesting question. I got the right answer but not by thinking it all the way through so I learned something new - always a good way to start the morning!

RE: Unary & Aliases

ronmoses — Tue, 13 Sep 2011 05:52:25 GMT

I'm hoping by this afternoon I will have read the explanation enough times to understand it, because I sure as heck don't at this hour of the morning! ;-)ron

RE: Unary & Aliases

Britt Cluff — Tue, 13 Sep 2011 05:45:17 GMT

Good question. I admit I had to run it to get the correct answer. Just couldn't visaulize it in my head.

RE: Unary & Aliases

Thomas Abraham — Tue, 13 Sep 2011 05:33:48 GMT

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.

RE: Unary & Aliases

Danny Ocean — Tue, 13 Sep 2011 05:17:00 GMT

Nice question, But i got it wrong.

RE: Unary & Aliases

codebyo — Tue, 13 Sep 2011 05:02:58 GMT

Thank you for the question.Had to think this one through because of the operators.And the variable was just to mess with us? :-PBest regards,

RE: Unary & Aliases

Håvard — Tue, 13 Sep 2011 02:49:49 GMT

Thanks for the question.I got it wrong, and learned something!

RE: Unary & Aliases

Stewart "Arturius" Campbell — Tue, 13 Sep 2011 02:13:43 GMT

Interesting questionThanks

RE: Unary & Aliases

khelloufsofiane 6183 — Tue, 13 Sep 2011 02:02:47 GMT

Thanks for the question.:)

RE: Unary & Aliases

Iulian -207023 — Tue, 13 Sep 2011 01:16:33 GMT

Thank you for the question, regards,Iulian

RE: Unary & Aliases

Koen Verbeeck — Tue, 13 Sep 2011 00:23:36 GMT

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.

Unary & Aliases

Carlo Romagnano — Mon, 12 Sep 2011 21:45:12 GMT

Comments posted to this topic are about the item [B]Unary & Aliases[/B]