SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by jrtupa / SELECT (Transact-SQL) / Latest Posts

RE: SELECT (Transact-SQL)

kapil_kk — Sat, 03 Nov 2012 01:36:15 GMT

Thanks Danny :-)

RE: SELECT (Transact-SQL)

@Cassie — Mon, 29 Oct 2012 14:50:42 GMT

Easy question.It shows once again, the more options/possibilities, the more errors can be made.

RE: SELECT (Transact-SQL)

asifkareem — Mon, 29 Oct 2012 14:15:06 GMT

Good Exercise for Basic of SQL.Nice OneThanks:-)

RE: SELECT (Transact-SQL)

Danny Ocean — Mon, 29 Oct 2012 06:39:43 GMT

[quote][b]kapil_kk (10/25/2012)[/b][hr]One question, I am confused on this...select ID, name name from personselect ID ID, name name from personBoth these statements dont give any error message and run successfully...wht is it so?[/quote]Hi kapil,1st statement :- it's showing that you are giving the alias column name to column 2(name). I can also right this like:- select ID, name as [name] from person or select ID, name as [Column_2] from person 2nd Statement :-same thing happen in 2nd statement.Check below statement. have funselect '--------------------' as TTselect 233 as '____________' ThanksVinay

RE: SELECT (Transact-SQL)

Danny Ocean — Mon, 29 Oct 2012 06:33:46 GMT

opps, i have selected wrong answer in hurry.

RE: SELECT (Transact-SQL)

Revenant — Sat, 27 Oct 2012 12:44:15 GMT

Easy one... Thanks!

RE: SELECT (Transact-SQL)

swarn_soft — Fri, 26 Oct 2012 11:57:33 GMT

nice and easy question to check the basics

RE: SELECT (Transact-SQL)

Meow Now — Fri, 26 Oct 2012 11:55:11 GMT

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

RE: SELECT (Transact-SQL)

KWymore — Fri, 26 Oct 2012 11:13:30 GMT

nice easy one for a Friday. Thanks!

RE: SELECT (Transact-SQL)

dawargo — Fri, 26 Oct 2012 09:51:46 GMT

D'oh! Hit the wrong option...

RE: SELECT (Transact-SQL)

Paul White — Fri, 26 Oct 2012 07:40:37 GMT

If Microsoft ever decide to replace the T-SQL parser with a human, they won't choose me.

RE: SELECT (Transact-SQL)

Lynn Pettis — Fri, 26 Oct 2012 07:24:32 GMT

An easy, back to basics question.

RE: SELECT (Transact-SQL)

mtassin — Fri, 26 Oct 2012 07:03:55 GMT

Thanks, I needed an easy Friday question... the coffee machines are out of order today.

RE: SELECT (Transact-SQL)

Dan Graveen — Fri, 26 Oct 2012 06:23:12 GMT

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. :-)

RE: SELECT (Transact-SQL)

(Bob Brown) — Fri, 26 Oct 2012 05:59:14 GMT

Thanks. I needed an easy one for Friday. Confused me for a second with having 5 possible answers and showing only 4 examples but was awake enough to get it right.

RE: SELECT (Transact-SQL)

Thomas Abraham — Fri, 26 Oct 2012 05:21:59 GMT

Thanks for the question. A basic but clear one. Just right for a Friday. More?

RE: SELECT (Transact-SQL)

JoseACJr — Fri, 26 Oct 2012 04:11:46 GMT

[quote][b]Lokesh Vij (10/25/2012)[/b][hr][quote][b]demonfox (10/25/2012)[/b][hr]I found the glitch ..nice question...thanks[/quote]A trick to catch the glitch.1) Use SSMS, go to "Query" and select "IntelliSense Enabled"2) Copy paste the code3) the syntax error in the query (with error) will be highlighted with zig-zag red line :-)Check the attached image.[img]http://www.sqlservercentral.com/Forums/Attachment12639.aspx[/img][/quote][b]Thanks to all![/b]Ps: don´t "copy paste the code", ok ?;-)

RE: SELECT (Transact-SQL)

Stewart "Arturius" Campbell — Fri, 26 Oct 2012 02:39:43 GMT

Nice, simple, back-to-basics question, thanks

RE: SELECT (Transact-SQL)

palotaiarpad — Fri, 26 Oct 2012 01:59:34 GMT

An easy basic question! Thanks!

RE: SELECT (Transact-SQL)

Lokesh Vij — Thu, 25 Oct 2012 23:46:42 GMT

[quote][b]demonfox (10/25/2012)[/b][hr]I found the glitch ..nice question...thanks[/quote]A trick to catch the glitch.1) Use SSMS, go to "Query" and select "IntelliSense Enabled"2) Copy paste the code3) the syntax error in the query (with error) will be highlighted with zig-zag red line :-)Check the attached image.[img]http://www.sqlservercentral.com/Forums/Attachment12639.aspx[/img]

RE: SELECT (Transact-SQL)

kapil_kk — Thu, 25 Oct 2012 23:41:45 GMT

Thanks Koen and Lokesh :)

RE: SELECT (Transact-SQL)

Lokesh Vij — Thu, 25 Oct 2012 23:33:09 GMT

[quote][b]kapil_kk (10/25/2012)[/b][hr]One question, I am confused on this...select ID, name name from personselect ID ID, name name from personBoth these statements dont give any error message and run successfully...wht is it so?[/quote]'coz they are syntactically correct. They follow the belew rule[code="plain"]SELECT <column_name> [optional "AS" keyword] [optional <alias_name>]FROM <table_name>[/code]Alias_name can be same as that of column_name. Hope it is clear now

RE: SELECT (Transact-SQL)

Koen Verbeeck — Thu, 25 Oct 2012 23:28:55 GMT

[quote][b]kapil_kk (10/25/2012)[/b][hr]One question, I am confused on this...select ID, name name from personselect ID ID, name name from personBoth these statements dont give any error message and run successfully...wht is it so?[/quote]Think both statements as the following:[code="sql"]select ID, name [AS] name from person;select ID [AS] ID, name [AS] name from person[/code]The AS keyword is optional when used for aliases in the SELECT statement.

RE: SELECT (Transact-SQL)

Koen Verbeeck — Thu, 25 Oct 2012 23:27:32 GMT

An easy one to close the week, thanks!

RE: SELECT (Transact-SQL)

demonfox — Thu, 25 Oct 2012 23:15:06 GMT

I found the glitch ..nice question...thanks

RE: SELECT (Transact-SQL)

kapil_kk — Thu, 25 Oct 2012 23:14:31 GMT

One question, I am confused on this...select ID, name name from personselect ID ID, name name from personBoth these statements dont give any error message and run successfully...wht is it so?

RE: SELECT (Transact-SQL)

malleswarareddy_m — Thu, 25 Oct 2012 22:31:02 GMT

Easy question.Thanks

RE: SELECT (Transact-SQL)

Lokesh Vij — Thu, 25 Oct 2012 21:58:15 GMT

An easy one for Friday :-)Apparantly, I noticed that there were 4 select statements in the question and 5 select statements as the answer choice :-D

RE: SELECT (Transact-SQL)

kalyani.k478 — Thu, 25 Oct 2012 21:25:58 GMT

Easy question..thanks:)

RE: SELECT (Transact-SQL)

SQLRNNR — Thu, 25 Oct 2012 21:16:05 GMT

Thanks for the question.

RE: SELECT (Transact-SQL)

L' Eomot Inversé — Thu, 25 Oct 2012 21:04:45 GMT

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.

RE: SELECT (Transact-SQL)

JoseACJr — Thu, 25 Oct 2012 20:53:51 GMT

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

RE: SELECT (Transact-SQL)

bitbucket-25253 — Thu, 25 Oct 2012 20:23:24 GMT

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

SELECT (Transact-SQL)

JoseACJr — Thu, 25 Oct 2012 20:22:48 GMT

Comments posted to this topic are about the item [B]SELECT (Transact-SQL)[/B]