Difference between Triggers and Stored Procedure
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
Mention the uses of stored procedures.
How to create new tables with "select ... Into" statements in ms sql server?
Explain concepts of analysis services?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Explain datetimeoffset data type in sal server 2008?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is sql server management studio? : sql server management studio
What is the openxml statement in sql server?
What are the different types of cursor?
What are the built in functions in sql server?
What is 1nf 2nf?
In what three ways is the return statement used in a stored procedure?
Write an SQL query to obtain the 2nd highest salary.
What is the difference between coalesce() & isnull()?
What is the Main Difference between ACCESS and SQL SERVER?