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
If user is owning any SQL Objects, can we drop that user
Differentiate between mongodb vs. Sql server?
Explain what is public role in sql server?
What are temporal tables in sql server 2016?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How do I find the default sql server instance?
Explain why variables called the most powerful component of ssis?
How much does sql server 2016 cost?
How to get the definition of a trigger back?
What is a result set object returned by odbc_exec()?
What is 2nf in normalization?
How many triggers you can have on a table?
what changed between the previous version of sql server and the current version? : Sql server database administration
What is unique key constraint?
Mention a few common trace flags used with sql server?