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
Explain Capacity planning to create a database? and how to monitor it?
How to delete duplicate rows?
explain different types of backups avaialabe in sql server? : Sql server database administration
How do I know if localdb is running?
What is user-defined inline table-valued function?
What is implicit mode in sql server?
What is CTE in SQL
Do you know what are acid properties?
What is a fan-out query in SQL Azure?
List the advantages of using stored procedures?
How to include text values in sql statements?
Explain the truncate command? : SQL Server Architecture
Define full outer join in sql server joins?
Can I disable or restrict ssrs export formats (rendering formats)?
What is ddl command?
