All commands of sql fall in one of the following categories.
2. DML (Data Manipulation Language) The statements that falls under this category are used to update data or add or remove data from tables. UPDATE, DELETE and INSERT commands fall under this category. 3. DCL (Data Control Language) It is used to control who access the data. The commands that come under this category are GRANT and REVOKE 4. TCL (Transaction Control Language) This language is used to commit data and restore data. COMMIT and ROLLBACK falls under this category. 5. DQL (Data Query Language) This is to retrieve data from sql server. SELECT statement falls in this category. All above languages are SQL. They are just categories of SQL. they are not different from SQL. |
Tuesday, December 30, 2008
SQL: Types of sub languages in SQL
Subscribe to:
Post Comments (Atom)



0 comments:
Post a Comment