Share via

SQUARE (Transact-SQL)

  • Article

Returns the square of the specified float value.

Topic link iconTransact-SQL Syntax Conventions

Syntax

SQUARE ( float_expression )

Arguments

  • float_expression
    Is an expression of type float or of a type that can be implicitly converted to float.

Return Types

float

Examples

The following example returns the volume of a cylinder having a radius of 1 inch and a height of 5 inches.

DECLARE @h float, @r float
SET @h = 5
SET @r = 1
SELECT PI()* SQUARE(@r)* @h AS 'Cyl Vol'

Here is the result set.

Cyl Vol
--------------------------
15.707963267948966

See Also

Reference

Mathematical Functions (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance