PI (Transact-SQL)

Returns the constant value of PI.

Transact-SQL Syntax Conventions

Syntax

PI ( )

Return Types

float

Examples

The following example returns the value of PI.

SELECT PI()
GO

Here is the result set.

------------------------
3.14159265358979

(1 row(s) affected)

See Also

Reference

Mathematical Functions (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance