square

Syntax

square(numeric_expression)

Parameters

• numeric_expression – is a numeric expression of type float.

Examples

• Example 1 – Returns the square from an integer column:

  select square(total_sales)from titles
  ------------
  16769025.00000
  15023376.00000
  350513284.00000
  ...
  16769025.00000
  (18 row(s) affected)

• Example 2 – Returns the square from a money column:

  select square(price) from titles
  -----------
  399.600100
  142.802500
  8.940100
  NULL
  ...
  224.700100
  (18 row(s) affected)

Usage

This function is the equivalent of power(numeric_expression,2), but it returns type float rather than int.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute square.