3
Contributors
3
Replies
18
Views
4 Years
Discussion Span
Last Post by Deeksh
0

there are many methods in MSSQL depending on your requirement(ceiling(),round() or floor())

  • ceiling() method :- Returns the smallest integer greater than, or equal to, the specified numeric expression.
  • round() method :- Returns a numeric value, rounded to the specified length or precision.
  • floor() method :- Returns the largest integer less than or equal to the specified numeric expression.

take a look at all mathematical functions avialable http://msdn.microsoft.com/en-us/library/ms177516.aspx

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.