RetiredDBA.com

RetiredDBA.com provides tidbits, ideas and insights to all things Microsoft SQL Server.

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

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

This div height required for enabling the sticky sidebar

Sponsor Ads



RetiredDBA Websites

ACTIVE
FOR SALE
Just OutletsChicago Job Resource
Retired DBALuxury Matters
Tradin Stuff
Value Buyers