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 can sql server instances be hidden? : sql server security
How to verify a login name with sqlcmd tool?
What is “asynchronous” communication in sql server service broker?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What does top operator do?
Is it possible to create trigger on views?
List the ways in which dynamic sql can be executed?
What does the update command do?
What is open database communication (odbc)?
What is dynamic cursor in SQL SERVER?
What are the types of sql server?
How are the unique and primary key constraints different?
What are the extra roles available in msdb? : sql server security
What is triggers and stored procedures?
