Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11
SSMS 9

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Question of the month June 2011- SELECT 7A

Jun 8 2011 1:24AM by Madhivanan   

I am starting this series of questions which will be posted every month. You may find them interesting to answer. This is the question for this month.

What does SQL Server return for the following select statement? 

SELECT 7A

Post your answer and breifly explain the output.

Keep following this series for interesting questions

Tags: t-sql, sql_server, sqlserver, tsql, Quiz, question,

Madhivanan
3 · 39% · 12430
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect


Submit

5  Comments  

  • Wow Nice ! Please post the answer as well

    commented on Jun 20 2011 5:48AM
    krishnavamshi24
    523 · 0% · 70

  • It will return 7 as output and A as column name as it takes A as alias to column name like if u do to simplify Select 7 A or Select 7 As A or Select 7A7 now 7 would be output and A7 would be column name so after number it takes that as column name

    commented on Jun 21 2011 3:20AM
    adnanaman
    2895 · 0% · 2

  • Never thought this way. Good to learn something new.

    commented on Jun 24 2011 11:05AM
    pk_bohra
    731 · 0% · 44

  • Any Update on this

    commented on Jul 11 2011 4:43AM
    krishnavamshi24
    523 · 0% · 70

  • krishnavamshi24, the answer SQL Server parses the string and as soon as it finds an alphapet(with the exception of E) after number, it treats it as a alias name. You may also need to read this http://beyondrelational.com/justlearned/posts/114/implicit-conversion-in-the-column-alias-name.aspx

    commented on Jul 11 2011 4:51AM
    Madhivanan
    3 · 39% · 12430

Your Comment
Sign Up or Login to post a comment.
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]