Download
100% FREE
Office Document APIs for .NET
Online: 1117
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Bookmarks
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Forums
>
Sql Server
>
Loading ...
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
|
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
Login to post response
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 ...