Difference between Triggers and Stored Procedure
- 23 Answers
- 69320 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / pankaj arya
To use stored procedure you have to make a call to that
procedure but Triggers fired automatically when an event is
occurred on the table associated with that Trigger like add,
insert or delete.
| Is This Answer Correct ? | 108 Yes | 7 No |
Post New Answer View All Answers
What is policy based management (pbm)? : sql server database administration
Which is better statement or preparedstatement?
What are the different types of triggers in SQL SERVER?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
Why we use the openxml clause?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
what's the difference between a primary key and a unique key? : Sql server database administration
Delete duplicate rows without using rowid.
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
How can we improve performance by using SQL Server profiler?
Can select statements be used on views in ms sql server?
Does sql server 2000 full-text search support clustering?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Differentiate between delete and truncate.
Can you get second highest salary from the table?
