Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73623 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / madhu prakash p
sp and trigger are both predefined set of sql statements
we can pass the arguments for sp but we cant pass the
arguments for triggers.
trigger will fire implicitly, when ever relavent action
performed by the user on the tables where the triggers are
placed.
But in the stored procedures u must call explicitly.
| Is This Answer Correct ? | 43 Yes | 9 No |
Post New Answer View All Answers
What is filestream?
What are the main sources of data?
Describe in brief sql server monitoring ways.
How self join is different from outer join?
What is the rdl file?
What are the restrictions applicable while creating views? : SQL Server Architecture
What is row_number () and partition by in sql server?
What are the differences between web role and worker role?
What are the types of subscriptions in SQL Server replication?
What do you understand by physical_only option in dbcc checkdb?
We need to perform what steps in the following order to work with a cursor?
Create and insert into temp table in sql server?
How can delete duplicate records in cte in sql server?
What’s the distinction between dropping a info and taking a info offline?
What happens to a statement batch if there is a compilation error?
