Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffrent between store procedure and trigger
- 2 Answers
- 5295 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 |
Can we perform backup restore operation on tempdb? : sql server database administration
Explain alternate key, candidate key and composite key in sql server?
Define self join?
Explain about sql server login?
How will you monitor replication latency in transactional replication? : sql server replication
How to specify the collation for a character data type in ms sql server?
What happens when converting big values to integers?
How do I find the size of a sql server database?
What is difference between views and stored procedures?
Explain about link server in sql server?
What are the differences between char and varchar in ms sql server?
How many types of local tables are there in sql server?
-
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)
