Interested to Buy Any Domain ? << Click Here >> for more details...
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
Is it important for a database administrator to understand the operating system and file access?
When we should use @@error?
What is the difference between join and inner join?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is an index. What are the types?
How to skip remaining statements in a loop block using continue statements?
How to insert and update data into a table with "insert" and "update" statements?
What is the use of for clause?
What is field in algebra?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How to perform backup for certificates in sql server? : sql server security
What is page in sql server?
What are the types of subscriptions in SQL Server replication?
How to add code to the existing article (using improve article)?
How will you add a dimension to cube? : sql server analysis services, ssas
