Answer Posted / m.ramarathna
Triggers are special kind of stored procedure that get
executed automatically when insert,update,delete operation
takes place on a table. Trigger can't be invoked on demand.
when delete,update,insert one data in the table ,that data
will stored in another one table.Nobody can't open the table
.That can open only by the select user.because of trigger
we give full importants to all data .
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What do you understand by SQL*Net?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Define constraints and give an example of their use?
How to replace null values in expressions using isnull()?
What are system databases in ms sql server?
What are different types of subquery?
What are audit control procedures?
What is meant by indexing?
Give the query of getting last two records from the table in SQL SERVER?
What is a db view?
How to list all field names in the result set using mssql_field_name()?
What are the steps you can take to avoid “deadlocks”?
Explain about service Broker functions?
What does truncate do?
How are the exceptions handled in sql server programming?