Top 3 things to know about T-SQL (Transact SQL)

You should review all the options of these commands in the SQL Server books (BOL) especially when upgrading to a new version of SQL Sever.

1 – DDL – Data Definition Language commands are used to manage schema objects like databases, tables, triggers.
ALTER
CREATE
DISABLE TRIGGER
DROP
ENABLE TRIGGER
RENAME
UPDATE STATISTICS

2 – DML – Data Manipulation language commands are used to manage data.
BULK INSERT
DELETE
INSERT
MERGE
SELECT
TRUNCATE TABLE
UPDATE

3 – DCL – Data control language commands are used to manage security permissions.
GRANT
REVOKE