DML
DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.
Examples: SELECT, UPDATE, INSERT statements
DDL
DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database.
Examples: CREATE, ALTER, DROP statements
DCL
DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it.
Examples: GRANT, REVOKE statements
TCL
TCL is abbreviation of Transactional Control Language. It is used to manage different transactions occurring within a database.
Examples: COMMIT, ROLLBACK statements
Reference : Pinal Dave (https://blog.sqlauthority.com)
170 Comments. Leave new
Dear readers please tell which command act as a both DDL and DML Command.
DML : Insert, Update, Delete, Merge.
DDL : Create, Alter, Drop, Rename, Truncate.
TC : Commit, Rollback, Savepoint.
DCL : Grant, Revoke.
plz explain me with example how to commit and rollback in sqlserver at staring level how it work with query example
Hi Mr. Pinal Dave,
I am Prasanna – learner and new at SQL
can you please explain that how do I takkle the problem below.
I have three tables A, B and C
A – Temperory data
B – All Raw data
C – History Data
please note that the table structure and column names are same in all three tables.
I have updated data in table A.
I already have some old data in table B.
Table C is empty.
Now I want to append the updated data (records) from table A to table B. However there may be duplicate records found while appending the data. I dont want to delete duplicate data(records) found from table B. I just want to move that records from table B to table C and append the updated data from table A to table B. The first column is Identicle in all three tables –
Note :- The first column is SO Number and there are 1000 SO number which are 5 digits number and there may be multiple records under 1 particular SO.
Please tell me the stored procedure for this.
Thanks & Regards,
Prasanna
its so impressive
give me some examples of DQL AND DRL ,is SELECT command belongs to both of these langusges?
sir can i have sql dba experienced resumes
sir plz send me experienced resumes of sql dba
RDBMS means ?
Relational DataBase Management System
THNX
SIRJI
Sir plz tell me
what is rename, truncate, grant, revoke, commit and rollback in database?
please tell me exact defination of those query. please sir
I am a student at klu (vijayawada) i cant understand what my professor is teaching but i am familier with SQL as i m reading u r posts….
THANKS A LOT
is MsSQL and SQL server are same?
sir i want the ddl dml dcl tcl commands syntax’s…..
one extra DQL data query language and select is part of dql not dml only three are part of dml insert, update, delete.
why do we call ‘alter’ a ddl command?
sir I want to know is there Comment Statement in DDL. Plz reply fast……………..!!!!!!!!!!!!
What did you mean by Comment statement?
sagar
alter table and alter database are ddl cmd only
…as we are modifying or defining database structure and object
thanks a lot for ur repl..
and why do we call select a DML cmnd?
All Commands are very useful
thats good but, I want the whole information of DDL, DCL, DML, TCL.
actually now I am study in s.y. BCA….in s.p. uni.