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
What is 1nf 2nf?
What is user-defined multi-statement table-valued function?
How to rebuild all indexes on a single table?
How can I tell if sql server is 32 or 64 bit?
What is after dml trigger?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What is the difference between web edition and business edition?
Describe in brief authentication modes in sql server.
What are triggers? How do you invoke a trigger on demand?
What is the difference between a view and a stored procedure?
Mention the differences between sql server and mysql.
How to test odbc dsn connection settings?
What is the current pricing model of SQL Azure?
how to invoke a trigger on demand? : Sql server database administration
What's the information that can be stored inside a bit column?
