SELECT (Transact-SQL)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by jrtupa » SELECT (Transact-SQL)

34 posts, Page 3 of 4

«««1 2 3 4 »»

SELECT (Transact-SQL)

Rate Topic

Display Mode

Topic Options

Author

Message

Dan Graveen

Posted Friday, October 26, 2012 6:23 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, October 31, 2012 6:27 AM
Points: 369, Visits: 62

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. Smile

Post #1377535

mtassin

Posted Friday, October 26, 2012 7:03 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 5:36 PM
Points: 3,229, Visits: 64,279

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

Lynn Pettis

Posted Friday, October 26, 2012 7:24 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 3:44 PM
Points: 21,624, Visits: 27,463

An easy, back to basics question.

Cool

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

Paul White

Posted Friday, October 26, 2012 7:40 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 5:10 PM
Points: 10,989, Visits: 10,535

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

dawargo

Posted Friday, October 26, 2012 9:51 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:16 AM
Points: 332, Visits: 206

D'oh! Hit the wrong option...

Post #1377701

KWymore

Posted Friday, October 26, 2012 11:13 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:57 PM
Points: 2,575, Visits: 1,533

nice easy one for a Friday. Thanks!

Post #1377753

Meow Now

Posted Friday, October 26, 2012 11:55 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:15 PM
Points: 471, Visits: 485

After I pulled the pencil from my eye and reformatted the question...easy to spot. w00t

Aigle de Guerre!

Post #1377768

swarn_soft

Posted Friday, October 26, 2012 11:57 AM

SSC-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

Revenant

Posted Saturday, October 27, 2012 12:44 PM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 1:00 PM
Points: 3,459, Visits: 2,535

Easy one... Thanks!

Post #1377972

Danny Ocean

Posted Monday, October 29, 2012 6:33 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 8:01 AM
Points: 1,083, Visits: 1,160

opps, i have selected wrong answer in hurry.

Keep Learning - Keep Growing !!!
http://growwithsql.blogspot.in

Thanks
Vinay Kumar

Post #1378218

« Prev Topic | Next Topic »

34 posts, Page 3 of 4

«««1 2 3 4 »»

Permissions