Using Transact-SQL

Microsoft SQL Server uses a variation of SQL called Transact-SQL that further extends the capabilities of SQL. This following table lists topics in SQL Server 2005 Books Online that describe Transact-SQL and how to use it to accomplish basic database tasks.

Task	SQL Server 2005 Books Online topic
Understand Transact-SQL	Elements of Transact-SQL Query Fundamentals Parts of a SELECT Statement Using the FROM Clause Filtering Rows by Using WHERE and HAVING Database Engine Stored Procedures (Transact-SQL) System Stored Procedures (Transact-SQL)
Implement a database	CREATE DATABASE (Transact-SQL) ALTER DATABASE (Transact-SQL) DELETE (Transact-SQL) INSERT (Transact-SQL) DROP DATABASE (Transact-SQL) DROP TABLE (Transact-SQL) SELECT (Transact-SQL) SELECT Examples (Transact-SQL) UPDATE (Transact-SQL)
Optimize a database	CREATE INDEX (Transact-SQL) CREATE VIEW (Transact-SQL) ALTER INDEX (Transact-SQL) ALTER VIEW (Transact-SQL)
Maintain a database	BACKUP (Transact-SQL) RESTORE (Transact-SQL) SHUTDOWN (Transact-SQL)