Unary & Aliases

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 Carlo Romagnano » Unary & Aliases

26 posts, Page 2 of 3

««1 2 3 »»

Unary & Aliases

Rate Topic

Display Mode

Topic Options

Author

Message

ronmoses

Posted Tuesday, September 13, 2011 5:52 AM

SSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 10:36 AM
Points: 651, Visits: 688

I'm hoping by this afternoon I will have read the explanation enough times to understand it, because I sure as heck don't at this hour of the morning! Wink

ron

-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown

Post #1174047

Ernie Schlangen

Posted Tuesday, September 13, 2011 6:07 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 6:32 AM
Points: 1,592, Visits: 352

Thanks for an interesting question. I got the right answer but not by thinking it all the way through so I learned something new - always a good way to start the morning!

Post #1174054

rfr.ferrari

Posted Tuesday, September 13, 2011 6:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:51 AM
Points: 1,219, Visits: 13,507

good and easy question!

rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!

Post #1174084

KWymore

Posted Tuesday, September 13, 2011 8:09 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:59 AM
Points: 2,579, Visits: 1,537

Interesting stuff. Thanks for the question.

Post #1174194

Revenant

Posted Tuesday, September 13, 2011 8:36 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:20 PM
Points: 3,462, Visits: 2,539

Excellent question - thank you!

Post #1174239

charles evans

Posted Tuesday, September 13, 2011 11:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 21, 2011 12:17 PM
Points: 103, Visits: 158

I think I may need eye glasses, I really had to look hard at the commas to differentiate them from periods... I almost chose the Incorrect Syntax error.

Post #1174405

Artur Komkov

Posted Tuesday, September 13, 2011 1:00 PM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 1:40 PM
Points: 385, Visits: 229

My first opinion was: very exotic question far away from practical usage.
But later I changed my minds. Never thought about arithmetical operations in T-SQl work in such way. Thanks a lot.

Post #1174448

SQLRNNR

Posted Tuesday, September 13, 2011 1:21 PM

SSCoach

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

Nice 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 #1174460

CoolCodeShare

Posted Tuesday, September 13, 2011 2:56 PM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, May 18, 2013 11:44 PM
Points: 1,216, Visits: 297

It's a nice and interesting question. Thanks.

Post #1174500

Olga B

Posted Tuesday, September 13, 2011 4:02 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 22, 2013 5:58 PM
Points: 561, Visits: 440

Ah yes, my "favorite" bit of SQL syntax

select 0 [A]

A fun bug to find when I accidentally delete a comma and then try to figure out what's wrong with the output of

select col1
       col2, 
       col1003
from sometable

What? I can't be the only one! Ermm

Thanks for the question!

Post #1174535

« Prev Topic | Next Topic »

26 posts, Page 2 of 3

««1 2 3 »»

Permissions