Monday, July 23, 2012

Usage of Triggers in Microsoft SQL Server


Triggers are used in Microsoft SQL Server for various purpose. These are used when :
  1. Creation of audit log of database activity.
  2. For applying business rules.
  3. For applying calculation on data from tables which is not stored in them.
  4. To enforce referential integrity.
  5. When alter data in a third party application needed.
  6. To execute SQL statements as a result of an event or condition automatically.


1 comment:

  1. We at Low cost website design dallas believe in providing low cost web design solutions per client specifications. Our strength lies with the skilled professionals who embrace fresh ideas in areas of high quality theme based design, sparkling web design layouts, web colours with stylish copy and inventive presentation. An eye for perfection and a key sense of layouts and designs set us a class apart. We make small business big business in Low cost website design dallas, Texas.For more information http://www.flashwebz.com/.

    ReplyDelete