This chapter describes each of the Transact-SQL functions. Functions are used to return information from the database. They are allowed in the select list, in the where clause, and anywhere an expression is allowed. They are often used as part of a stored procedure or program.
See the Transact-SQL Users Guide, Chapter 16, “Using Transact-SQL Functions in Queries,” 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.
