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 ...

Get Developing and Implementing Windows®-Based Applications with Visual C#™ .NET and Visual Studio® .NET Exam Cram™ 2 (Exam 70-316) now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.