What is the difference between DDL and DMLtriggers?

Posted by Neeks under Sql Server on 2/7/2009 | Views : 10946 | Status : [Member] | Replies : 6

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Can anyone tell me the difference between DDL and DML triggers? I want to us the trigger. So please provide the examples if it is possible.
Thanks in Advance

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Sriramnandha on: 5/25/2012 [Member] Starter | Points: 25

0	DDL(DATA DEFINATION LANGUAGE) CREATE ,DELETE DML(DATA MANUPULATION LANGUAGE) INSERT,UPDATE,DELETE DDL TRIGGER IS USED FOR CREATE TABLE,DELETE TABLE DML TIGGER IS USED INSERT,UPDATE,DELETE REGARDS sriram Neeks, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Muhsinathk on: 6/12/2012 [Member] Bronze | Points: 25

0	http://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/ http://rahulgbhatia.wordpress.com/2012/03/28/what-are-the-difference-between-ddl-dml-and-dcl-commands/ Neeks, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ravianand on: 6/12/2012 [Member] Starter | Points: 25

0	Refer below link http://www.linkedin.com/answers/technology/information-technology/information-security/TCH_ITS_ISC/804231-16576065 Regards, Ravi Neeks, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Raja on: 2/8/2009 [Member] Starter

0	DDL is Data Definitaion Langauge and it contains command like Create Table, Drop table etc. Where DDL Trigger is a kind of triggers that contains command like Create trigger, update triggers etc. For complete understanding, please visit http://www.developer.com/db/article.php/3552096 Thanks Regards, Raja, USA Neeks, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Neeks on: 2/8/2009 [Member] Bronze

0	This helped me lot. Neeks, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Neeks on: 2/8/2009 [Member] Bronze

0	Thanks Raja. Neeks, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts

Six s-e-a-t-e-r d.i.n.i.n.g table for sale Bradford UK (0)New
6 s.e.a.t.e.r d.i.n.i.n.g table for sale Swansea UK (0)New
D.e.s.i.g.n.e.r Jobs Edinburgh UK (0)New
Nepal Honeymoon Package (0)New
What to do when Adobe reader installation failed? (0)New
No 1 Nursing Essay Help Writing Service UK | Hire Experts Now (1)Updated
How to Find count Details Sql server (0)
sharepoint installation system requirements (0)
More ...