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)
  • Last updated on