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
What are the default system databases in sql server 2000?
Explain boyce and codd normal form(bcnf)?
What is measure group, measure? : sql server analysis services, ssas
What happens if the update subquery returns no rows in ms sql server?
State the difference between union and union all?
What are the results of running this script?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How to restore performance issues and how to check?
How do we know if any query is retrieving a large amount of data or very little data?
What is a matrix in ssrs?
what are different types of raid configurations? : Sql server database administration
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Indexes are updated automatically is the full-text index also updated automatically?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Where is my database stored on the hard disk in ms sql server?
