Difference between Triggers and Stored Procedure
- 23 Answers
- 70085 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / naveen jindal
trigger fired implicitely that is when ever events like
insert/update/delete commands.
Where as stored procedure is not fired implicitely. when
ever we call then only the stored procedure fire.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
how many type of indexing in database?
Explain transaction server consistency?
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?
What are the basic features of a trigger in ms sql server?
Does an index slow down updates on indexed columns?
What is change tracking in sql server?
What is primary key, unique key, and foreign key?
How can I check that whether automatic statistic update is enabled or not?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
Tell me when is the update_statistics command used?
why would you use sql agent? : Sql server database administration
What is inner join? Explain with an example?
What is coalesce and check constraint in sql server?
What is the difference between drop table and truncate table?
How to use union to merge outputs from two queries together in ms sql server?
