Topic: Triggers in SQL
Not finding your answer? Try searching the web for Triggers in SQL
Answers to Common Questions
How to Delete Triggers in Microsoft SQL 2000
Triggers are Structured Query Language (SQL) code that executes each time you edit records in your SQL Server 2000 database. To delete a trigger, you must execute SQL code in the SQL Server's code editor. The code executes against the SQL S... Read More »
Source: http://www.ehow.com/how_7160782_delete-triggers-microsoft-sql-200...
What is Database triggers in sql?
A database trigger is an action that the database management software will perform automatically when a preset list of conditions are met. Different database vendors have different mechanisms in place for the declaration of triggers, but th... Read More »
Source: http://wiki.answers.com/Q/What_is_trigger_in_sql
What is Trigger is SQL Server 2005?
A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are stored in and managed by the DBMS.Triggers are used to maintain the referential integrity of data by changing the data in a ... Read More »
Source: http://wiki.answers.com/Q/What_is_Trigger_is_SQL_Server_2005
More Common Questions
Answers to Other Common Questions
Why not trigger in SQL Server 2000? I think you need to understand what the definition of a database trigger is in this case. A database trigger is simply code that the database system will trigger when a certain event occurs. The classic e...
Read More »
Source: http://wiki.answers.com/Q/Why_need_trigger_in_sql_server_2000
A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. A trigger is really an event handler. SQL Server allows users to create triggers (event handlers) for 3 types of events...
Read More »
Source: http://www.fixya.com/support/t735152-trigger_in_sql
if using sql 2000: select * from sysobjects where type = 'tr' if using 2005: select * from sys.triggers Also, in 2005, if you expand the table you can find the triggers. In 2000, you also look at the table properties. HTH, Tim
Read More »
Source: http://www.experts-exchange.com/Q_23247768.htm
When you click on "New Trigger" it opens a query window pane in which you write the trigger. From there you can save the text to disk or run the DDL query to save it in the data base: just click on the red exclamation point.
Read More »
Source: http://www.experts-exchange.com/Q_22968767.htm
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculat...
Read More »
Source: http://wiki.answers.com/Q/Define_the_role_of_a_trigger_point
A trigger is a special procedure, associated with a table, that is executed automatically when anything changes that table. You can designate a trigger to fire when one or more rows in the table are updated, deleted, inserted, or any/all of...
Read More »
Source: http://answers.yahoo.com/question/index?qid=20071224055628AAiKg0H
OK..so you're inserting into the parent first....good deal. create trigger mytriggername on parenttablename after insert as begin insert into childtable1(empid, otherfields...) select empid, otherfields... from inserted insert into childtab...
Read More »
Source: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Serv...
