.net asap

Thursday, September 5, 2013

Problem >> Round value to two decimal value in sql .
Solution >>
select round(100/50.0,2),cast(round(100/50.0,2) as numeric(36,2))
Returns
20.000000   20.00
Posted by Anonymous at 7:03 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2015 (1)
    • ►  May (1)
  • ►  2014 (15)
    • ►  April (1)
    • ►  March (1)
    • ►  February (13)
  • ▼  2013 (18)
    • ▼  September (10)
      • Step by Step procedure to install sharepoint 2010 ...
      • Step by step process to install sahrepoint 2007 on...
      • Step by Step process to Install Sharepoint 2010 on...
      • Problem >> Object moved here  in asp.net ? c#? Sol...
      • Probelm>> How To Add Hyperlink to gridview element...
      • Problem >> Round value to two decimal value in sql...
      • Problem >> SQL : Error converting data type varcha...
      • Problem>> How to write Dynamic sql Query? Solution...
      • Problem>> Dynamic sql query in stored procedure er...
      • Problem>> How to clear the dropdown value to defau...
    • ►  August (8)
Simple theme. Powered by Blogger.