SQUARE (T-SQL)

Returns the square of the given expression.

Syntax

SQUARE(float_expression)

Arguments

float_expression

Is an expression of type float.

Return Types

float

Examples

This 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:

Cyl Vol

--------------------------

15.707963267948966

See Also