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 are the differences between sql server and mysql.
How can I tell if sql server is 32 or 64 bit?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What is a cube? : sql server analysis services, ssas
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Explain how you can configure a running aggregate in SSRS?
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 is the difference between update lock and exclusive lock?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
Explain steps of normalization?
What types of replication are supported in sql server?
You want to implement the one-to-one relationship while designing tables. How would you do it?
How to change parameter value inside the report?