Transact-SQL Reference
SQUARE
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