T-SQL Tutorial

T-SQL - Useful Resources

The following resources contain additional information on T-SQL. Please use them to get more in-depth knowledge on this.

T-SQL - Numeric Functions

MS SQL Server numeric functions can be applied on numeric data and will return numeric data.

T-SQL - Date Functions

Following is the list of date functions in MS SQL Server.

T-SQL - String Functions

MS SQL Server String functions can be applied on string value or will return string value or numeric data.

T-SQL - Functions

MS SQL Server has many built-in functions to perform processing on string or numeric data. Following is the list of all useful SQL built-in functions ?

T-SQL - Indexes

Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in a database is very similar to an index at the end of a book.