T-SQL Parsing Crazy Eights

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 John Arnott » T-SQL Parsing Crazy Eights

40 posts, Page 1 of 4

1 2 3 4 »»»

T-SQL Parsing Crazy Eights

Rate Topic

Display Mode

Topic Options

Author

Message

john.arnott

Posted Monday, September 21, 2009 10:14 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:57 PM
Points: 1,491, Visits: 3,008

Comments posted to this topic are about the item T-SQL Parsing Crazy Eights

Post #791499

Joy Smith San

Posted Monday, September 21, 2009 10:42 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 3:25 AM
Points: 1,371, Visits: 2,302

Good question.

Post #791506

ChiragNS

Posted Tuesday, September 22, 2009 12:34 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

real cracker.

"Keep Trying"

Post #791527

dgvozdetsky

Posted Tuesday, September 22, 2009 2:09 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 6:06 AM
Points: 1,685, Visits: 90

Very interesting and good question Smile

Post #791568

RichB

Posted Tuesday, September 22, 2009 3:19 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 4:24 AM
Points: 1,026, Visits: 752

haha, someone should submit that to the daily wtf... Hehe

Post #791598

sjimmo

Posted Tuesday, September 22, 2009 6:41 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 7:15 AM
Points: 2,865, Visits: 2,467

Great question - thought provoking. Had to re-read a couple of times

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

Post #791714

BudaCli

Posted Tuesday, September 22, 2009 8:07 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 9:02 AM
Points: 1,046, Visits: 573

This really got me confused, for a sec I almost thought that it was an error ans

What you don't know won't hurt you but what you know will make you plan to know better

Post #791787

Tao Klerks

Posted Tuesday, September 22, 2009 8:30 AM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, April 14, 2013 8:55 AM
Points: 1,383, Visits: 1,212

Very fun Q :)

I particularly like "3+8E8Eight"

http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.

Post #791823

webrunner

Posted Tuesday, September 22, 2009 9:01 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 1:47 PM
Points: 2,118, Visits: 2,213

Great question. I couldn't believe that such a wacked-out query would work.

webrunner

-------------------
"The chemistry must be respected." - Walter White

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

Post #791885

aboyce

Posted Tuesday, September 22, 2009 9:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 22, 2011 11:27 AM
Points: 136, Visits: 15

The answer depends on where the query is run. If run from SQL Server Management Studio, you get the answer given. With the 9 columns being:
E (No name) ight Eight E8E Eight (No name) ight Eight
However, when I ran the same query in Microsoft Visual Studio's Query window I got different column names:
E E Eight Eight E8E Eight Expr1 Eight Eight

The data was the same in both cases.

Post #791891

« Prev Topic | Next Topic »

40 posts, Page 1 of 4

1 2 3 4 »»»

Permissions