Wrox Programmer Forums
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 9th, 2008, 06:33 AM
Authorized User
Join Date: Dec 2006
Posts: 62
Thanks: 0
Thanked 0 Times in 0 Posts
Default Triggers

what is meant by mutating error in triggers? Could you please explain in detail.
Also pls. tell me when to use Triggers as most of the programmability can be coded using Stored procedures, any specify areas where Trigger plays a bigger role compared to Stored procedures.

Thanks in advance

Old April 12th, 2008, 01:35 AM
Friend of Wrox
Join Date: Aug 2004
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts

Triggers and stored procedures are completely different based on what executes them. A trigger as the name implies is "triggered" on an event. You can have an Insert Trigger and an Updated trigger for example. So the insert trigger code executes when you insert a row into a table. The Update Table trigger code executes when you do an update. If you do a select or delete on the table no triggers execute. A stored procedure is code that sits on the server until you specifically call it. Similar to running an *.exe on windows. It sits there till you call it up.

Good luck with your home work or interview.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Triggers? odezzie Classic ASP Databases 1 March 28th, 2007 06:09 PM
Triggers mrookey SQL Server 2000 2 October 24th, 2006 07:11 AM
Triggers? prabodh_mishra Oracle 2 March 30th, 2006 05:51 AM
Triggers shahchi1 SQL Server 2000 1 November 1st, 2004 06:28 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.