.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Types of triggers

Posted By: Narayanan     Posted Date: December 24, 2011    Points:5   Category :Sql Server
What are the types of triggers? give an example

Responses
Author: Syed Shakeer Hussain             
Posted Date: December 24, 2011     Points: 20   

Triggers are of 3 types in SQL Server 2005:
1. DML Triggers
. AFTER Triggers
. INSTEAD OF Triggers
2. DDL Triggers
3. CLR Triggers


for more information check the below link
http://www.dotnetspark.com/kb/657-how-to-create-trigger.aspx '>http://www.dotnetspark.com/kb/657-how-to-create-trigger.aspx

Author: kamlesh             
Posted Date: December 28, 2011     Points: 20   

Hi,
for more information about Trigger check below link.

http://www.codeproject.com/KB/database/TriggersSqlServer.aspx
http://msdn.microsoft.com/en-us/library/ms189799.aspx
http://www.sql-server-performance.com/2007/trigger-tuning/
http://www.allinterview.com/showanswers/112138.html

Thanks And Regards.
Kamlesh Nikam
Author: Narayanan             
Posted Date: January 02, 2012     Points: 20   

Hi,
Thanks for your reply...

Regards, Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend