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 are scalar functions?
How to perform backup for certificates in sql server? : sql server security
Explain the architecture of ms sql reporting service?
What are wait types?
What command must you use to include the not null constraint after a table has already been created?
Do you know what is normalization of database? What are its benefits?
What does Master database contains?
What is an example of a foreign key?
Explain left outer join and right outer join?
What are “lock” hints?
Ways to improve the performance of a SQL Azure Database?
what are different types of raid configurations? : Sql server database administration
How do you make a trace?
How to enforce security in sql server? : sql server security
How to provide login information for a new odbc dsn?
