Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffrent between store procedure and trigger
- 2 Answers
- 5254 Views
- I also Faced
- E-Mail Answers
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 |
How to rebuild all indexes on a single table?
What are the features of Embedded SQL
What is the difference between having and where clause?
What are the properties of primary key?
what is blocking? : Sql server database administration
Explain isolation levels that sql server supports?
What is difference between equi join and natural join?
Explain few examples of stored procedure over triggers?
Do you know query execution plan?
How can change procedure in sql server?
Difference between Cluster and Non-cluster index?
32 Answers Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,
can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.
-
Oracle (3259) - 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)
