A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE,
or DELETE statements on a table or view.
chandan777
Member
189 Points
256 Posts
Triggers for a begginer
Jan 25, 2013 06:19 AM|LINK
Hi
I am new to MS SQL. I want to know from basic , what are triggers ? In which situations we can use triggers with asp.net c# Applications?
How to write triggers? What are the advantages and disadvantages of triggers?
Please help!
wmec
Contributor
6228 Points
3226 Posts
Re: Triggers for a begginer
Jan 25, 2013 06:42 AM|LINK
A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view.
Read
http://msdn.microsoft.com/en-us/library/ms189799%28v=SQL.100%29.aspx
HuaMin Chen
yrb.yogi
Star
14460 Points
2402 Posts
Re: Triggers for a begginer
Jan 25, 2013 07:47 AM|LINK
I would suggest to start from http://www.w3schools.com/SQl/default.asp and I just found this linkhttp://topofblogs.com/academics/very_easy_way_to_learn_sql_using_example_query by googling "learn SQL fast"
For good forum regarding T-SQL language I can recommend http://social.msdn.microsoft.com/Forums/en-US/transactsql/threads (I check this forum in free time). There are also several other good forums, I use tek-tips forum http://tek-tips.com/threadminder.cfm?pid=183, there is also SQLServerCentral.com forum.
.Net All About