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
Why do we partition data?
what are constraints? Explain different types of constraints? : Sql server database administration
Explain having clause and where clause?
Why truncate is ddl?
Explain datetimeoffset data type in sal server 2008?
What is 2nf normalization form?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
How can I check if a view exists in a sql server database?
What is report rendering ?
What is raid? : SQL Server Architecture
What do you understand by the data quality services in sql server?
What is cursors? And what are the different types of cursor?
What is application role in sql server database security? : sql server security
What is page-level compression?
Why we use functions in sql server?
