Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73451 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / manoj kopardekar
STORED PROCEDURE
A stored procedure is an already written SQL statement that
is saved in the database. We can run the stored procedure
from the database's command environment
1.Precompiled execution. SQL Server compiles each stored
procedure once and then reutilizes the execution plan. This
results in tremendous performance boosts when stored
procedures are called repeatedly.
2.Reduced client/server traffic. If network bandwidth is a
concern in your environment, you'll be happy to learn that
stored procedures can reduce long SQL queries to a single
line that is transmitted over the wire.
3.Efficient reuse of code and programming abstraction.
Stored procedures can be used by multiple users and client
programs. If you utilize them in a planned manner, you'll
find the development cycle takes less time.
4.Enhanced security controls. You can grant users permission
to execute a stored procedure independently of underlying
table permissions.
TRIGGER
A trigger is an object contained within an SQL Server
database that is used to execute a batch of SQL code
whenever a specific event occurs. As the name suggests, a
trigger is “fired” whenever an INSERT, UPDATE, or DELETE SQL
command is executed against a specific table.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the stored procedure?
Why use sub query in sql server and list out types of sub queries?
What is sql server agent and what are the two modes of authentication in sql server?
What is sql server replication? : sql server replication
Indexes are updated automatically is the full-text index also updated automatically?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is faster join or union?
What are ddl triggers and types of ddl trigger?
Who developed sql server?
When would you prefer to have a minimum number of indexes?
What are the essential components of sql server service broker?
How do we Backup SQL Azure Data?
Does full backup break log chain?
What is plan freezing?
What is the default order of an order by clause?
