Difference between Triggers and Stored Procedure
- 23 Answers
- 69773 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / naveen jindal
trigger fired implicitely that is when ever events like
insert/update/delete commands.
Where as stored procedure is not fired implicitely. when
ever we call then only the stored procedure fire.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
List the different normalization forms?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Explain about Joins?
Explain system views?
What is data source in connection string?
What is field with example?
Can We Use Data-grids For Our Report In Ssrs?
What are translations and its use? : sql server analysis services, ssas
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is data source document?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Do you know spatial data types - geometry and geography in sql server 2008?
How to connect sql server management studio express to sql server 2005 express?
explain different types of joins? : Sql server database administration
Can we call future method from queueable?
