Arithmetic 1

Question

Viewing 6 posts - 31 through 36 (of 36 total)

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

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 1

Interesting question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

muni.reddy SSC Rookie Points: 47 More actions · Answer 2

For any numeric operation to be successful, atleast one of the operand must be a number data type.

e.g. select '6'+'4'*'8'/'2' will fail where as

select '6'+4*'8'/'2' will succeed.

Thus it is obvious that the execution expression 2 fails.

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 3

Good question. Thanks for submitting.

http://brittcluff.blogspot.com/

manik_anu SSCrazy Points: 2397 More actions · Answer 4

nice question.....

Manikandanps

------Go fast as possible---------------

Manik
You cannot get to the top by sitting on your bottom.

Hany Helmy SSChampion Points: 13921 More actions · Answer 5

Nice one, thanx

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

RubySWorld SSCommitted Points: 1777 More actions · Answer 6

SSCommitted

Points: 1777

October 11, 2015 at 11:19 am

Made me thinking. Good question by the way.

Cookies on SQLServerCentral