What is a trigger?
Answers were Sorted based on User's Feedback
Answer / guest
Triggers are basically used to implement business rules.
Triggers is also similar to stored procedures. The
difference is that it can be activated when data is added or
edited or deleted from a table in a database.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / hari
Trigger is a special kind of storedprocedure automatically
executed when DML Operations done.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kumar
In simpler words, triggers act BEHIND-THE-SCENE once they
are created.They are extremely powerful feature of SQL
Server but not exploited fully to the extent they could be..
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / mukesh kumar srivastava
A trigger is a special kind of stored procedure that responds to specific events. There are two kinds of
triggers: Data Definition Language (DDL) Triggers and Data Manipulation Language (DML) Triggers.
Is This Answer Correct ? | 1 Yes | 0 No |
Is the log file is a part of file group?
Explain error handling in ssis?
Can you create a logon trigger in sql server 2005 express edition?
What is self contained sub query?
Does group by or order by come first?
can you instantiate a com object by using t-sql? : Sql server database administration
Do you know what are the restrictions that views have to follow?
What is sql stored procedure?
Show Practically Sql Server Views are updatable?
How do I create a stored procedure in sql server?
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)
Is null in sql server?