Difference between Triggers and Stored Procedure

Answer Posted / amar

triggers is a block of code where is fired to do something action for insertion or delation of varioue t- sql statement........ where triggers are automatically fired.........

stored procedure is a predefined data types which is stored in a database............ stored procedure has to fire...........

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we check the sql server version?

739


Why normalization is used?

728


How can you list all the table constraints in a database?

697


How to add a new dsn with the odbc driver for sql server?

738


What happens if null values are involved in bitwise operations?

796






Write a SQL queries on Self Join and Inner Join.

791


Explain the different types of joins?

745


How to download and install microsoft .net framework version 2.0?

748


What does it mean to normalize a database and why would you do it?

727


Why are sql functions used?

773


What is tablix?

136


What is difference between clustered and non clustered index?

702


What new data source types were added in ssrs 2014?

130


What is recompile sql server?

756


What is ms sql server reporting services?

726