Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73463 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / vikas sinha
1)Stored Procedure can call.but trigger is automatically
invoked when action defined in trigger is done.
2)Stored procedure can not be inactive.but trigger can be
active and inactive.
3)Stored Procedure may or may not reture a value.but
trigger will not return a value.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is reportserver and reportservertempdb ?
How is sql used in sql server?
Where in ms sql server is ’100’ equal to ‘0’?
What are the options which must be set to allow the usage of optimistic models?
What is etl - extraction, transformation, and loading?
What is dbcc updateusage?
According to you what goes into making the best database administrator? : sql server database administration
How do you migrate data from mssql server to azure?
What are the advantages to use stored procedures?
What is the difference between the 2 operating modes of database mirroring?
What is abstracting periodical?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
How to delete a login name in ms sql server?
can an automatic recovery be initiated by a user? : Sql server administration
Which database stores information about replication?
