SQL SERVER – A Puzzle – Illusion – Confusion – April Fools’ Day
- by pinaldave
Today is April 1st and just like every other year, I like to bring something interesting and light for the day. Atleast there should be days in every one’s life when they should feel easy. Here is a quick puzzle for you and I believe it will make you feel extremely smart if you can figure out the result behind the same.
Run following in SQL Server Management Studio and observe the output:
SELECT 30.0/(-2.0)/5.0;
SELECT 30.0/-2.0/5.0;
Here are few questions for you:
1) What will be the result of above two queries?
2) Why?
If you think you can figure out the result without executing them – I encourage you to execute BOTH of them in SSMS and see if they give you same result or different result.
Well, now I am waiting for your answer here – why? I often post similar things on my facebook page http://facebook.com/SQLAuth – you are welcome to play with me there.
Reference: Pinal Dave (http://blog.sqlauthority.com)
Filed under: PostADay, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology
