Advertisement

04.02.2008 at 01:25PM PDT, ID: 23290788
[x]
Attachment Details

How do you reference a column name by an alias in an SQL select statement?

Asked by toddvoros in SQL Query Syntax, Databases Miscellaneous, MS SQL Server

How do you reference a very long SQL column name in a select statement by an alias in Microsoft SQL server?  For example, "select this_is_a_very_long_column_name from mytable" where you would like to give a shorter alias name to "this_is_a_very_long_column_name".Start Free Trial
Related Solutions: How to select records starting with a to z or A to Z only using the "like" clause?
[+][-]04.02.2008 at 01:26PM PDT, ID: 21267122

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.02.2008 at 01:27PM PDT, ID: 21267126

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.02.2008 at 01:36PM PDT, ID: 21267226

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.02.2008 at 01:39PM PDT, ID: 21267254

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.02.2008 at 01:40PM PDT, ID: 21267261

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.02.2008 at 01:40PM PDT, ID: 21267271

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.02.2008 at 02:00PM PDT, ID: 21267478

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Query Syntax, Databases Miscellaneous, MS SQL Server
Sign Up Now!
Solution Provided By: dbbishop
Participating Experts: 4
Solution Grade: A
 
 
[+][-]04.02.2008 at 02:02PM PDT, ID: 21267498

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.02.2008 at 02:26PM PDT, ID: 21267706

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628