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 1 of 4

1 2 3 4 »»»

SELECT (Transact-SQL)

Rate Topic

Display Mode

Topic Options

Author

Message

JoseACJr

Posted Thursday, October 25, 2012 8:22 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 7:25 AM
Points: 439, Visits: 229

Comments posted to this topic are about the item SELECT (Transact-SQL)

Post #1377356

bitbucket-25253

Posted Thursday, October 25, 2012 8:23 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:13 PM
Points: 5,103, Visits: 20,214

Here we go back to the basics once again ....

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1377357

JoseACJr

Posted Thursday, October 25, 2012 8:53 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 7:25 AM
Points: 439, Visits: 229

It was necessary to practice the basics to get where he is today!

Post #1377365

L' Eomot Inversé

Posted Thursday, October 25, 2012 9:04 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 7,110, Visits: 7,184

Nice clean question.

But maybe a little too easy. If one assumes that T-SQL has the sort of consistent syntax that most programming languages have, then only the second and fourth options are possible answers (since if either of the otherw was wrong then so would at leat one more be wrong, and the radio buttons allow for only one); so the only question is whether the "as" keyword can be omitted or whether "a as b" and "b as a" mean the same thing - but letting those mean the same thing would mean one couldn't cope with renaming a column with another solumn's name, whic would be rather odd, so the principle of minimising oddity (which in my experience applies to all languages except C++) tells us the answer straight away.

Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.

Post #1377368

SQLRNNR

Posted Thursday, October 25, 2012 9:16 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 10:25 AM
Points: 18,754, Visits: 12,337

Thanks for the question.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1377372

kalyani.k478

Posted Thursday, October 25, 2012 9:25 PM

SSChasing Mays

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 1:45 AM
Points: 616, Visits: 97

Easy question..thanks:)

Post #1377374

Lokesh Vij

Posted Thursday, October 25, 2012 9:58 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 1,176, Visits: 1,253

An easy one for Friday Smile

Apparantly, I noticed that there were 4 select statements in the question and 5 select statements as the answer choice BigGrin

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1377379

malleswarareddy_m

Posted Thursday, October 25, 2012 10:31 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 9:44 PM
Points: 1,852, Visits: 987

Easy question.Thanks

Malleswarareddy
I.T.Analyst
MCITP(70-451)

Post #1377388

kapil_kk

Posted Thursday, October 25, 2012 11:14 PM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:16 PM
Points: 1,061, Visits: 1,151

One question, I am confused on this...

select ID, name name from person

select ID ID, name name from person

Both these statements dont give any error message and run successfully...
wht is it so?

Post #1377393

demonfox

Posted Thursday, October 25, 2012 11:15 PM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074, Visits: 1,076

I found the glitch ..
nice question...

thanks

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one Ermm

Post #1377395

« Prev Topic | Next Topic »

34 posts, Page 1 of 4

1 2 3 4 »»»

Permissions