Trailing

Question

Post reply

Trailing

Steve Jones - SSC Editor

SSC Guru

Points: 737892
More actions
October 10, 2016 at 9:50 pm

#75750

Comments posted to this topic are about the item Trailing

Viewing 15 posts - 1 through 15 (of 21 total)

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

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

I'll admit, this one got me. :hehe:

Thanks for the question.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Rune Bivrin SSCrazy Eights Points: 8589 More actions · Answer 2

This is a quite uesful anomaly. It allows for easy cut'n'paste between table creation scripts, without worrying about deleting any trailing commas or having commas between constraints.

Just because you're right doesn't mean everybody else is wrong.

Thom A SSC Guru Points: 99137 More actions · Answer 3

Really wasn't expecting that answer. The skeptic in me does wonder how many people ran the SQL before giving an answer though

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Okay, that's a little weird. Microsoft has updated the language to allow syntactically incorrect SQL based on popular habits. I see why they did it, but I don't agree with it.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Mike Hays SSCommitted Points: 1871 More actions · Answer 5

Mike Hays

SSCommitted

Points: 1871

October 11, 2016 at 5:17 am

#1905860

Wow!!! Did not see that one coming.... :laugh:

Rune Bivrin SSCrazy Eights Points: 8589 More actions · Answer 6

Ed Wagner (10/11/2016)
Okay, that's a little weird. Microsoft has updated the language to allow syntactically incorrect SQL based on popular habits. I see why they did it, but I don't agree with it.

Oh, it's been like that for a long time. The same applies when initializing arrays in C#, by the way. Quite handy, if you ask me, and completely benign.

Just because you're right doesn't mean everybody else is wrong.

Kaye Cahs SSCarpal Tunnel Points: 4135 More actions · Answer 7

Thom A (10/11/2016)
Really wasn't expecting that answer. The skeptic in me does wonder how many people ran the SQL before giving an answer though

I'm one of the people who ran the SQL before submitting my answer. I view it as testing, not cheating.

In this case, I was surprised by the results. I really expected it to return an error.

barry.mcconnell Default port Points: 1447 More actions · Answer 8

Interestingly, if you examine Information Schema Columns, the table only has 3 columns.

There are no facts, only interpretations.
Friedrich Nietzsche

Rune Bivrin SSCrazy Eights Points: 8589 More actions · Answer 9

barry.mcconnell (10/11/2016)
Interestingly, if you examine Information Schema Columns, the table only has 3 columns.

I'd be a lot more surprised if there were more columns than that. Without a name or data type there isn't much to go on.

It's just a syntactical convenience where each item can be followed by a comma.

Just because you're right doesn't mean everybody else is wrong.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 10

akljfhnlaflkj

SSC Guru

Points: 76202

October 11, 2016 at 7:46 am

#1905898

It just feels wrong.

Revenant SSC-Forever Points: 42467 More actions · Answer 11

Iwas Bornready (10/11/2016)
It just feels wrong.

I would say 'counterintuitive'.

Thanks to Steve for a provocative one.

webrunner SSC-Dedicated Points: 31973 More actions · Answer 12

Thanks for the question. I got it right only because I've seen it work. Not sure why it is allowed, though.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

doug.davidson SSCommitted Points: 1662 More actions · Answer 13

Thom A (10/11/2016)
Really wasn't expecting that answer. The skeptic in me does wonder how many people ran the SQL before giving an answer though

I selected my answer (execute with syntax warning).

Ran the SQL, kept my answer wrong, assuming it was a trick question because I SQL2012 and this would be a new feature in SQL2016.

Oh well, better luck next time.

demonfox SSCertifiable Points: 6289 More actions · Answer 14

I knew this one.

Thanks a lot for the question.

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

Trailing

Cookies on SQLServerCentral