Answer Posted / kalyana chakravarthy maddipati
A trigger is a stored procedure fires implicitly when ever a DML(Insert, update & Delete) occurs. It is stored at server side. Its compiled and no need to compile and execute always.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
When to use null data driven subscription?
What are the types of subscriptions in SQL Server replication?
What do you understand by triggers?
What is a not null constraint?
Explain about link server in sql server?
What is reportserver and reportservertempdb ?
What are the properties of primary key?
what is a mixed extent? : Sql server administration
What is the difference between grant and with grant while giving permissions to the user?
Explain why variables called the most powerful component of ssis?
How you can change a cross join into an inner join?
Explain about temporary stored procedure?
What do you mean by subquery?
What is normalization? What number of normalization shapes are there?
What is a file group?