Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 25, 2013 07:47 AM by yrb.yogi
Jan 25, 2013 06:19 AM|LINK
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?
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.
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.