Comments on: SQL SERVER – A Puzzle – Illusion – Confusion – April Fools’ Dayhttp://blog.sqlauthority.com/2012/04/01/sql-server-a-puzzle-illusion-confusion-april-fools-day/
SQL, SQL Server, MySQL, Big Data and NoSQLSat, 01 Aug 2015 16:25:24 +0000hourly1http://wordpress.com/By: klablabtesthttp://blog.sqlauthority.com/2012/04/01/sql-server-a-puzzle-illusion-confusion-april-fools-day/#comment-451675
Mon, 08 Apr 2013 07:57:18 +0000http://blog.sqlauthority.com/?p=17989#comment-451675Hi Pinal Sir,
First one is executing by the left hand over which parenthesis operator have hig ht priority so it will gives as 30.0/(-2.0)/5.0 will give as 30.0/(-2.0)=-15.0/.0=-3.0
so for second example 30.0/-2.0/5.0 will executed as -2.0/5.0 as unary operator have higher precedence so it will be executed as -2.0/5.0 give -0.4 then we have 30/-0.4 so it will give output as -0.75.

]]>By: Parth Malhanhttp://blog.sqlauthority.com/2012/04/01/sql-server-a-puzzle-illusion-confusion-april-fools-day/#comment-272857
Fri, 06 Apr 2012 09:22:41 +0000http://blog.sqlauthority.com/?p=17989#comment-272857Please use these statement and have fun:
By removing – we get the same result.
WHY?