what is diffrent between store procedure and trigger
Answers were Sorted based on User's Feedback
Answer / vandana chand
Stored Procedure is the set of SQl statements together in the
data base.
and Trigger is the Special kind of store procedure i.e called
whenever an attempt is to modify the data.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / sankar
1)Actually Trigger is an action which is performed
automatically after or before an event occure. But Store
procedure is executed when it is call.
2)We can call Trigger inside the store procedure. But
reverse is not possible.
| Is This Answer Correct ? | 1 Yes | 2 No |
What is a NOLOCK?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Difference between Cluster and Non-cluster index?
32 Answers Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,
what is dbcc? : Sql server database administration
What is the difference between login and a user?
13 Answers CTS, TCS,
What do you understand by the analysis services in sql server?
How can we Use Linked Server? Uses of Linked server
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What are page splits? : SQL Server Architecture
How to delete duplicate rows from table except one?
What is Primary key and foreign key? Give an example
select empid empname from employee What is the result for the about query?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)