Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Power of implicit conversion Expand / Collapse
Author
Message
Posted Sunday, September 25, 2011 12:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:05 PM
Points: 157, Visits: 292
Comments posted to this topic are about the item Power of implicit conversion
Post #1180593
Posted Sunday, September 25, 2011 1:30 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 7:06 AM
Points: 1,216, Visits: 308
An Interesting Question!
Post #1180676
Posted Monday, September 26, 2011 12:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
Easy, but interesting. Good way to start a Monday.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1180741
Posted Monday, September 26, 2011 1:12 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 8:13 AM
Points: 995, Visits: 981
Thank you for the question.

Regards,
Iulian
Post #1180756
Posted Monday, September 26, 2011 1:49 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:56 AM
Points: 1,415, Visits: 801
Excellent QOTD.
Post #1180766
Posted Monday, September 26, 2011 2:04 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 9:09 AM
Points: 3,088, Visits: 3,329
This question and the coffee help wake me up this morning - thanks

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1180768
Posted Monday, September 26, 2011 2:44 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 1,767, Visits: 6,387
Good question - shame there weren't more possible answers given, I only had to look at the first two, and would probably have got at least one of the others wrong if I'd had to guess at them!
Post #1180778
Posted Monday, September 26, 2011 3:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
Toreador (9/26/2011)
Good question - shame there weren't more possible answers given, I only had to look at the first two, and would probably have got at least one of the others wrong if I'd had to guess at them!

Or, you could have just looked at "C" and saw that '2' + '3' + 1 = 24 and none of the other possible answers had 24 as the answer. That excluded all others without even having to calculate anything else.
Post #1180792
Posted Monday, September 26, 2011 5:28 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 1:04 PM
Points: 900, Visits: 1,490
Great question.
The precedence of operators, in that case, will make all the difference.
Since it's math, if we use parenthesis, we'll get a different result as expected.

SELECT '2' + '3' * 1 -- = 5
GO
SELECT ('2' + '3') * 1 -- = 23
GO

A good way to start the week. ;)

Best regards,


Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2
Post #1180852
Posted Monday, September 26, 2011 5:38 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Good question. Thanks for making me think on a Monday morning.

http://brittcluff.blogspot.com/
Post #1180860
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse