Answer Posted / kaushik chatterjee
A trigger is some what simillar to stored procedure. It is
written to perform a set of predefined actions when a
perticular database objecy such as tables,views are
DELETED,INSERTED,UPDATED.
Triggers are implicitly called and are NOT instactiated by
the user. Once written, it will be called automatically by
the DBMS engine when a UPDATE/DELETE/INSERT operation is
performed on the database object for which the trigger is
intended or written.
Triggers can be written for any one of the 3 operations
written above or all of them.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How can delete duplicate records in cte in sql server?
What are entities and relationships?
How do I find the transaction log size in sql server?
Tell about MOM Tool(Microsoft Operator Manager)?
Can group by and orderby be used together?
Which Model uses the SET concept
What are the elements of dbms?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Explain trigger classes i.e. Instead of and after trigger?
What is filtered index?
How to verify a login name with sqlcmd tool?
How do I start sql server 2017?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What are the difference between clustered and a non-clustered index?
What is primary key and example?
