Triggers in sql sever

Question

What is the use of triggers in real time and if possible explain with one example.

Answer 1

Hi bharath234,

You should ask your question in the Getting started with SQL Server http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/threads.

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

Answer 2

Hi,

Please refer the link below,

http://msdn.microsoft.com/en-us/library/aa258254(v=sql.80).aspx

http://www.codeproject.com/Articles/7304/Brief-about-Triggers-in-SQL-Server-2000

http://www.redware.com/handbooks/sql_server_handbook/sql_server_triggers.html

---

Thanks,
Suresh
Please use Mark or Propose as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 3

What is the use of triggers in real time and if possible explain with one example.

Example: all different kind of software packages are updating a table, but not updating the ModifiedDate column. So you develop a trigger to UPDATE the modified date column in real time:

http://www.sqlusa.com/bestpractices2005/timestamptrigger/

Triggers are frequently misused as patches for database development shortcomings:

http://www.sqlusa.com/bestpractices/trigger-as-fix-it-all/

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012

Answer 4

Hello,

The below link might help you.

http://www.codeproject.com/Articles/25600/Triggers-Sql-Server

http://msdn.microsoft.com/en-us/library/ms189799.aspx