Transact-SQL Functions

Often used as part of a stored procedure or program, functions are allowed in the select list, in the where clause, and anywhere an expression is allowed, and are used to return information from the database.

See the Using Transact-SQL Functions in Queries in the Transact-SQL Users Guide for detailed information about how to use these functions.

See XML Services for detailed information about the XML functions: xmlextract, xmlparse, xmlrepresentation, xmltable, xmltest, and xmlvalidate.

The permission checks for Transact-SQL functions differ based on your granular permissions settings. See the Security Administration Guide for more information on granular permissions.