Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Implicit conversion in the column alias name

Jun 13 2011 10:51AM by Madhivanan   

It is self explanatory. Run these and see the output. It is wonder how clever SQL Server is to give a column alias

select 7A,7EF,7EE,7E2T
Read More..   [32134 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Madhivanan
2 · 40% · 13039
13
 
1
 
12
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

11  Comments  

  • Thats really awesome especially 7E2T, its very difficult to predict output........

    commented on Jun 13 2011 11:04AM
    Ramireddy
    3 · 40% · 12972
  • RamiReddy, Thanks for the feedback

    commented on Jun 13 2011 11:05AM
    Madhivanan
    2 · 40% · 13039
  • Glad to learn.

    Thanks for sharing.

    commented on Jun 13 2011 11:10AM
    Paresh Prajapati
    6 · 23% · 7533
  • Now that's a nice magic trick worth it's money! Thank-you, Madhivanan!

    commented on Jun 15 2011 1:52AM
    Nakul Vachhrajani
    4 · 36% · 11648
  • Thank you all for the feedbacks

    commented on Jun 15 2011 1:59AM
    Madhivanan
    2 · 40% · 13039
  • Nice one. Thanks for sharing

    commented on Jun 15 2011 2:37AM
    Hardik Doshi
    20 · 9% · 2864
  • Yeah, the last one was the most tricky :-)

    commented on Jun 15 2011 3:11AM
    Jacob Sebastian
    1 · 100% · 32235
  • Good Info Madhivanan

    commented on Nov 5 2013 1:23AM
    narendra.b106
    888 · 0% · 33
  • Nice Catch, Thanks for sharing

    commented on Nov 7 2013 10:47PM
    vanan084
    2825 · 0% · 4
  • kool

    tricky, but explainable:

    Select 7 as A -- this is clear: column alias "A"

    Select 7 A -- same as previous, short form. Similar you can do ".. FROM person AS p .." or ".. FROM person p .."

    Select 7A -- it read the value which can be recognized only as number, and rest, not parseable part counted as column name - same logic works above

    Select 7EF -- same as above, but here "E" is parsed as part of number in scientific format: 7e2 = 7*(10^2)

    Select 7E2T -- scientific format: 7e2 = 700 with alias "T"

    commented on Nov 12 2013 10:18AM
    vadim
    1522 · 0% · 14
  • In fact the idea under the example is valid everywhere when SQL server can distinguish column name/value with column alias, See the link http://www.tectalks.com/386/sql-server-column-aliases/

    commented on Nov 21 2013 11:04PM
    Anoo S Pillai
    1441 · 0% · 15

Your Comment


Sign Up or Login to post a comment.

"Implicit conversion in the column alias name" rated 5 out of 5 by 13 readers
Implicit conversion in the column alias name , 5.0 out of 5 based on 13 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]