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 mscorsvw.exe - process - microsoft .net framework ngen?
What are system databases into sql server (2005/2008)?
How to assign new column names in a view?
Describe triggers features and limitations?
Explain Geography datatype in SQL Server
How to turn off warning messages during php execution?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
In case you have filters in your report, when filters will be applied in cached report instance?
What is the need for indexing?
What do you mean by a Composite primary key?
What do you understand by hotfixes and patches in sql server?
What is apply operator in sql?
How to modify existing triggers using "alter trigger"?
Explain microsoft sql server functions?
Define normalisation?
