Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73473 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / amar goala
The main differnce is that S.P. is explicitly calling for
execute else Onece a Trigger is created Its fired
automatically when any event
occurred like update,insert,delete on table in run time.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
How to throw custom exception in Stored Procedure?
What are the approximate numeric data types?
Can foreign key be deleted?
What are different backups available in sql server?
How do I clean up sql server transaction log?
What is difference between view and materialized view?
How to use old values to define new values in update statements in ms sql server?
Is the log file is a part of file group?
Can we write a distributed query and get some data which is located on other server and oracle database?
What happens when unicode strings concatenate with non-unicode strings?
What is an index. What are the types?
Explain the use of containers in ssis and also their types?
Mention the differences between substr and charindex in sql server.
What is enhanced database mirroring in sql server 2008?
