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 is used to retrieve ...