Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sandeep
First of all both are precompiled sql statements stored at
database server.
1. Stored procedures can return values to the caller
whereas triggers cant.
2. we cant call a trigger directly becos it is called by
the database server on an event(automatically raised on
insert,update,delete statements).
3. triggers can access datas from outside world(outside of
the Database).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to find the list of fixed hard drive and free space on server?
How to rename databases in ms sql server?
Do you know what is fill factor and pad index?
When would you use it?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
what are the disadvantages of cursors? : Sql server database administration
What is Dependency Injection and provide example?
What is extended stored procedures?
Which trace flags are enabled in sql server?
How to download and install sql server 2005 books online?
How to install sql server 2005 express edition?
What is PROJECTION Operation?
What is a unique index?
What happens when converting big values to numeric data types?
Define outer join?
