Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73472 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / veerababu
Stored Procedure is a method.
Trigger is a Procedure.
Stored Procedure a specific CALL or EXECUTE has be used.
Trigger is automatically execute some specific events occure in table/views.
Stored Procedure return a Value.
Trigger is not return a value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is the difference between varchar and varchar types?
Mention the different types of replication in sql server.
What are trace flags and mention a few common trace flags used with sql server?
Why do we backup Active Directory ?
How can a database be repaired?
Does the order of columns in update statements matter?
Explain differentiate between a having clause and a where clause?
Can we add a cpu to sql server?
Difference between 2NF &3NF ?
What are a scheduled jobs?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is the default port for SQL Server over a firewall?
What is SQL Azure Fabric?
How are the exceptions handled in sql server programming?
