Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73621 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / ajay panchal
Triggers are automatically run but stored procedures are not automatically run and they have to be called explicitly by the user.
we can write a stored procedure within a trigger but cannot write a trigger within a stored procedure.
Trigger is attached to table or view and is fired only when an INSERT, UPDATE, and/or DELETE occurs, while a stored procedure executes at any time when it is called.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the new security features added in sql server 2014? : sql server security
How will you decide the active and passive nodes?
Write SQL queries on Self Join and Inner Join.
How can you control the amount of free space in your index pages?
query processing
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.
How to find index size for each index on table?
What is a mixed extent?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
How to change the name of a database user?
Which table keeps the locking information?
Write a query for primary key constraint with identity key word?
Define a cross join?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Why do we use non clustered index?
