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 is indexing and its types?
What are the types of sql server?
What is deploy, process and build? : sql server analysis services, ssas
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What are the types of indexing?
Tell me about joins in database system and explain each in detail.
How the authentication mode can be changed?
Explain the different types of backups available in sql server? : sql server database administration
What is the default server name for sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
how will add additional conditions in sql?
Can you explain what is the use of custom fields in report?
Why is the need for data conversion transformations?
What is the purpose of grouping data in a report?
What are the 7 disadvantages to a manual system?