Previous Post
SQL SERVER 2008 – Connect Visual Studio 2005 Patch Download
Next Post
SQL SERVER – Check Database Integrity for All Databases of Server – DBCC CHECKDB

Related Posts

4 Comments. Leave new

  • How do i round 1.0847 to 1.09 using round function in sql server 2005

    wating for a reply

    thanks in advance .

    Reply
  • 1.0847 will not round to 1.09 (1.0857 would round to 1.09).

    Regardless the function is either:

    CONVERT(DECIMAL(3,2),1.0847) = 1.08

    or

    ROUND(1.0847, 2) = 1.0800

    Reply
  • You could also do this if you wanted to get 1.09 from 1.0857:

    SELECT CONVERT(DECIMAL(3,2),CONVERT(DECIMAL(4,3),1.0847))

    Convert twice the number to make 2 + 2 = 1 :0)

    Reply
  • Hi,
    @ archana
    try this. hope this will help u.

    select convert(decimal(3,2),convert(decimal(4,3),1.0847))

    Regards,
    Neetu

    Reply

Leave a Reply

Menu