SQL-Server-Functions

Functions let you replace and access strings and dates in SQL Server. You can call them passing times, tables, dates, and other variables, and get back results. Here are some articles to help you get started fast with functions, and help you learn how to pick the right function in SQL Server 2005 and 2008:

Common SQL Server Functions

These functions are the bread and butter of your stored procedures and views:

• SQL Server Aggregate Functions - like COUNT, MIN, MAX
• SQL Server Date Functions - like DATEPART, DATEADD and DATEDIFF
• SQL Server Cursor Functions - like @@FETCH, @@CURSOR_ROWS

SQL Server Replace Function

To replace characters in a string, use SQL Server 2005's built-in string functions:

• SQL Server Replace Function

SQL Server String Functions

SQL Server can do more than just replace characters in a string: it can also uppercase and lowercase strings, calculate string lengths, and more.

• SQL Server String Functions - like UPPER, SUBSTRING, LTRIM and RTRIM
• SQL Server Text Functions - for longer string fields in TEXT and NTEXT fields.

SQLServerPedia Editors' Favorite Articles on Functions

Our editors recommend these links:

• SQL Server 2000 Functions - if you can only develop against SQL Server 2000 servers, this list explains those functions that work on SQL 2000.
• SQL Server Configuration Functions - lets the database administrator query for @@MAX_CONNECTIONS, @@MAX_PRECISION, @@SERVERNAME and more.
• SQL Server Security Functions - like IS_SRVROLEMEMBER, USER, USER_NAME(), HOST_NAME