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 bookmark link in ssrs?
What is index in an assignment?
Which sql server table is used to hold the stored procedure script?
How do I uninstall sql server 2014?
What are the different SQL Server Versions you have worked on?
When would you use a before or after trigger?
What is rank function?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Can we shrink data file in sql server?
Explain primary key?
What are the types of processing and explain each? : sql server analysis services, ssas
What is correlated subquery in sql server?
Explain the etl (extraction, transformation, and loading)?
plss anybody specify tha constrian management system in dbms
Define clusters?
