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 use of except clause?
What is an index. What are the types?
What do you mean by the term 'normalization'?
What is the difference between the 2 operating modes of database mirroring?
Using the customer, and order table in northwind database, please write a query to produce xml?
Is there any difference between primary key and unique with the not null condition?
What is clustered index
What is the difference between cube operator and rollup operator? : SQL Server Architecture
If the job running very slow what is the action you do
How does clustered and non clustered index work?
Is sql server 2016 free?
What is the filtered index?
Explain about integration services of Microsoft SQL server?
What are the elements of dbms?
What is role playing dimension with two examples? : sql server analysis services, ssas
