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 «««1234»»

SELECT (Transact-SQL) Expand / Collapse
Author
Message
Posted Friday, October 26, 2012 6:23 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 04, 2013 9:43 AM
Points: 369, Visits: 65
I learned something new today. I've always used the "=" or "AS" when doing column aliases. So when I looked through the choices on this question, "select Id, name name from Person" seemed like the obvious answer, but fortunately I still looked at the remaining choices, and the last one, while easy to overlook if you skimmed the questions would not work as the column source is always on the right side of the equals.
I've been so used to using the AS or "=" I never thought you could omit them.
Post #1377535
Posted Friday, October 26, 2012 7:03 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: Tuesday, April 15, 2014 12:05 PM
Points: 3,569, Visits: 72,411
Thanks, I needed an easy Friday question... the coffee machines are out of order today.



--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1377556
Posted Friday, October 26, 2012 7:24 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:50 PM
Points: 22,509, Visits: 30,229
An easy, back to basics question.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1377573
Posted Friday, October 26, 2012 7:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 5:09 PM
Points: 11,168, Visits: 10,932
If Microsoft ever decide to replace the T-SQL parser with a human, they won't choose me.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1377580
Posted Friday, October 26, 2012 9:51 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, March 17, 2014 6:54 AM
Points: 383, Visits: 212
D'oh! Hit the wrong option...
Post #1377701
Posted Friday, October 26, 2012 11: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: Wednesday, April 16, 2014 9:46 AM
Points: 3,150, Visits: 1,900
nice easy one for a Friday. Thanks!
Post #1377753
Posted Friday, October 26, 2012 11:55 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Sunday, February 16, 2014 3:14 PM
Points: 471, Visits: 509
After I pulled the pencil from my eye and reformatted the question...easy to spot.

Aigle de Guerre!
Post #1377768
Posted Friday, October 26, 2012 11:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 26, 2013 1:07 PM
Points: 168, Visits: 117
nice and easy question to check the basics
Post #1377770
Posted Saturday, October 27, 2012 12:44 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:20 AM
Points: 4,245, Visits: 3,325
Easy one... Thanks!
Post #1377972
Posted Monday, October 29, 2012 6:33 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
opps, i have selected wrong answer in hurry.



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1378218
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse