Interested to Buy Any Domain ? << Click Here >> for more details...
Wht is the difference between stored procedure and trigger
- 6 Answers
- 14605 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / rajvelur
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 ? | 29 Yes | 3 No |
Post New Answer View All Answers
What language is sql server written in?
What is a data source or ds? : sql server analysis services, ssas
what's the maximum size of a row? : Sql server database administration
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
How do you send email on SQL Server?
List out different types of normalizations in sql server and explain each of them?
What are the difference between clustered and a non-clustered index?
What is similarity and difference between truncate and delete in sql?
Write an sql query to find first weekday of the month?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
How to find out the list schema name and table name for the database?
What is sql server profiler?
What do you understand by intent locks?
How to retrieve error messages using mssql_get_last_message()?
What are the types of table?
