What is the output of the following

Posted by Sheeba under ASP.NET on 11/3/2010 | Points: 10 | Views : 1421 | Status : [Member] | Replies : 3
Hi

SELECT ROUND(689.89, -1, 1)

Thank you




Responses

Posted by: Lalji_mer on: 11/3/2010 [Member] Bronze | Points: 25

Up
0
Down
by reference link i think Output is :688.00

[B}please check for reference
http://msdn.microsoft.com/en-us/library/aa238494%28SQL.80%29.aspx
http://msdn.microsoft.com/en-us/library/ms175003.aspx

LP MER

Sheeba, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prasham on: 11/5/2010 [Member] Starter | Points: 25

Up
0
Down
Hello,

Output is 688.00

Please refer following links for the details:

http://www.mssqltips.com/tip.asp?tip=1589

Thanks and Best Regards
Prasham

Sheeba, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 11/5/2010 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
Sheeba you are asking stange questions . Do you have SQL management studio ? you can run this by yourself

Thank you for posting at Dotnetfunda
[Administrator]

Sheeba, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response