Developing and Implementing Windows®-Based Applications with Visual C#™ .NET and Visual Studio® .NET Exam Cram™ 2 (Exam 70-316)

Transact-SQL

Microsoft's implementation of the Structured Query Language (SQL) standard is named Transact-SQL (T-SQL). T-SQL queries provide a flexible way of retrieving data from a SQL Server database or making changes to that database. The four main T-SQL statements that help you manipulate SQL Server data are as follows:

• SELECT statement— Used to retrieve stored data

• INSERT statement— Used to add new data

• UPDATE statement— Used to modify existing data

• DELETE statement— Used to remove existing data

T-SQL is derived from the American National Standards Institute (ANSI) SQL-92 standard.

The SELECT Statement

The SELECT statement is used to retrieve ...