Mathematical Functions

Artigo
04/12/2011

The .NET Framework Data Provider for SQL Server (SqlClient) provides math functions that perform calculations on input values that are provided as arguments, and return a numeric value result. These functions are in the SqlServer namespace, which is available when you use SqlClient. A provider's namespace property allows the Entity Framework to discover which prefix is used by this provider for specific constructs, such as types and functions.The following table describes the SqlClient math functions.

Function	Description
ABS(expression)	Performs the absolute value function. Arguments expression: An Int32, Int64, Double, or Decimal. Return Value The absolute value of the specified expression. Example `SqlServer.ABS(-2)`
ACOS(expression)	Returns the arccosine value of the specified expression. Arguments expression: A Double. Return Value A Double. Example `SqlServer.ACOS(.9)`
ASIN(expression)	Returns the arcsine value of the specified expression. Arguments expression: A Double. Return Value A Double. Example `SqlServer.ASIN(.9)`
ATAN(expression)	Returns the arctangent value of the specified numeric expression. Arguments expression: A Double. Return Value A Double. Example `SqlServer.ATAN(9)`
ATN2(expression, expression)	Returns the angle, in radians, whose tangent is between the two specified numeric expressions. Arguments expression: A Double. Return Value A Double. Example `SqlServer.ATN2(9, 8)`
CEILING(expression)	Converts the specified expression to the smallest integer that is greater than or equal to it. Arguments expression: An Int32, Int64, Double, or Decimal. Return Value An Int32, Int64, Double, or Decimal. Example `SELECT VALUE product FROM AdventureWorksEntities.Products AS product WHERE product.ListPrice == SqlServer.CEILING(product.ListPrice)`
COS(expression)	Calculates the trigonometric cosine of the specified angle in radians. Arguments expression: A Double. Return Value A Double. Example `SqlServer.COS(45)`
COT(expression)	Calculates the trigonometric cotangent of the specified angle in radians. Arguments expression: A Double. Return Value A Double. Example `SqlServer.COT(60)`
DEGREES(radians)	Returns the corresponding angle in degrees. Arguments expression: An Int32, Int64, Double, or Decimal. Return Value An Int32, Int64, Double, or Decimal. Example `SqlServer.DEGREES(3.1)`
EXP(expression)	Calculates the exponential value of a specified numeric expression. Arguments expression: A Double. Return Value A Double. Example `SqlServer.EXP(1)`
FLOOR(expression)	Converts the specified expression to the largest integer less than or equal to it. Arguments expression: A Double. Return Value A Double. Example `SELECT VALUE product FROM AdventureWorksEntities.Products AS product WHERE product.ListPrice == SqlServer.FLOOR(product.ListPrice)`
LOG(expression)	Calculates the natural logarithm of the specified float expression. Arguments expression: A Double. Return Value A Double. Example `SqlServer.LOG(100)`
LOG10(expression)	Returns the base-10 logarithm of the specified Double expression. Arguments expression: A Double. Return Value A Double. Example `SqlServer.LOG10(100)`
PI()	Returns the constant value of pi as a Double. Return Value A Double. Example `SqlServer.PI()`
POWER(numeric_expression, power_expression)	Calculates the value of a specified expression to a specified power. Arguments numeric_expression: An Int32, Int64, Double, or Decimal. power_expression: A Double that represents the power to which to raise the numeric_expression. Return Value The value of the specified numeric_expression to the specified power_expression. Example `SqlServer.POWER(2,7)`
RADIANS(expression)	Converts degrees to radians. Arguments expression: An Int32, Int64, Double, or Decimal. Return Value An Int32, Int64, Double, or Decimal. Example `SqlServer.RADIANS(360.0)`
RAND([seed])	Returns a random value from 0 through 1. Arguments Retruns the seed value as an Int32. If the seed is not specified, the SQL Server Database Engine assigns a seed value at random. For a specified seed value, the result returned is always the same. Return Value A random Double value from 0 through 1. Example `SqlServer.RAND()`
ROUND(numeric_expression, length [ ,function ])	Returns a numeric expression, rounded to the specified length or precision. Arguments numeric_expression: An Int32, Int64, Double, or Decimal. length: An Int32 that represents the precision to which numeric_expression is to be rounded. When length is a positive number, numeric_expression is rounded to the number of decimal positions specified by length. When length is a negative number, numeric_expression is rounded on the left side of the decimal point, as specified by length. function: (optional) An Int32 that represents the type of operation to perform. When function is omitted or has a value of 0 (default), numeric_expression is rounded. When a value other than 0 is specified, numeric_expression is truncated. Return Value The value of the specified numeric_expression to the specified power_expression. Example `SqlServer.ROUND(748.58, -3)`
SIGN(expression)	Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression. Arguments expression: Int32, Int64, Double, or Decimal Return Value An Int32, Int64, Double, or Decimal. Example `SqlServer.SIGN(-10)`
SIN(expression)	Calculates the trigonometric sine of the specified angle in radians, and returns a Double expression. Arguments expression: A Double. Return Value A Double. Example `SqlServer.SIN(20)`
SQRT(expression)	Returns the square root of the specified expression. Arguments expression: A Double. Return Value A Double. Example `SqlServer.SQRT(3600)`
SQUARE(expression)	Returns the square of the specified expression. Arguments expression: A Double. Return Value A Double. Example `SqlServer.SQUARE(25)`
TAN(expression)	Calculates the tangent of a specified expression. Arguments expression: Double Return Value Double Example `SqlServer.TAN(45.0)`

For more information about the mathematical functions that SqlClient supports, see the documentation for the SQL Server version that you specified in the SqlClient provider manifest:

SQL Server 2000	SQL Server 2005	SQL Server 2008
Mathematical Functions (Transact-SQL)	Mathematical Functions (Transact-SQL)	Mathematical Functions (Transact-SQL)

Partilhar via

Mathematical Functions

See Also

Concepts

Recursos adicionais