SELECT (Transact-SQL)

Question

Post reply

SELECT (Transact-SQL)

October 26, 2012 at 2:39 am

This was removed by the editor as SPAM

Viewing 15 posts - 16 through 30 (of 33 total)

You must be logged in to reply to this topic. Login to reply

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 1

palotaiarpad

SSCertifiable

Points: 5617

October 26, 2012 at 1:59 am

#1553059

An easy basic question! Thanks!

JoseACJr SSC Eights! Points: 934 More actions · Answer 2

Lokesh Vij (10/25/2012)
demonfox (10/25/2012)
I found the glitch ..
nice question...
thanks
A trick to catch the glitch.
1) Use SSMS, go to "Query" and select "IntelliSense Enabled"
2) Copy paste the code
3) the syntax error in the query (with error) will be highlighted with zig-zag red line 🙂
Check the attached image.

Thanks to all!

Ps: don´t "copy paste the code", ok ?

😉

Thomas Abraham SSChampion Points: 10761 More actions · Answer 3

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

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 4

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.

Dan Graveen Mr or Mrs. 500 Points: 525 More actions · Answer 5

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

mtassin SSC-Insane Points: 23099 More actions · Answer 6

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[/url]
For tips on how to post your problems[/url]