T-SQL » Introduction

Download free PDF version

By Shine

Welcome to the T-SQL Quick Reference. This is a comprehensive quick reference covering a wide range of topics, from the basic query operations, to more advanced features such as stored procedures, triggers, and views. The rich number of examples makes it easy to quickly get started.

SQL is a language used to communicate with relational databases. It defines operations for inserting, deleting, retrieving and updating information organized in tables. It is also used for managing databases. Although there are standards for SQL, such as ANSI SQL92 and SQL99, most databases use their own dialect and/or extentions. Microsoft's flavor of SQL used in SQL Server 7 and SQL Server 2000 is called T-SQL. While many of the examples in this quick reference may work on other databases, it is assumed that SQL Server 2000 is used, especially for advanced topics such as stored procedures.