Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shashi kishor prasad
1.Stored Procedures are Pre-compiled functions that needs to
be called but Triggers are event driven and can't be called
explicitly like stored procedures
2.Stored procedures can take arguments but Triggers dont
take arguments.
3.Stored procedures cant get executed unless they are called
by by the calling program but Triggers gets fired as soon as
an event for which it has been created takes place.
4. Stored procedures can work on the database and values it
has been assigned but Triggers can work on db other than that.
5.Stored Procedures are used to make the execution faster
and to prevent from sql injections to some extent but
Triggers are used to achieve different tasks on occurrence
of an event like insert update and delete on a table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we return Data from 4(more than 1) tables in stored procedure?
What is the native system stored procedure to execute a command against all databases?
How to generate create table script on an existing table in ms sql server?
What are the purpose of Normalisation?
How to identify current user in ssrs report?
What is the use of sql profiler in sql server 2012?
What are the disadvantages of merge replication?
What is an execution plan? How would you view the execution plan?
what are the different stages of Report Processing?
What structure can you implement for the database to speed up table reads?
Write the syntax for stuff function in an sql server?
Explain activity monitors
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What do you mean by 'normalization'?
What is the difference between nvl and nvl2?
