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
What are Spatial data types in SQL Server 2008
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Do comments need to go in a special place in sql server 2005?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What is the chart in report?
what is create database syntax? : Sql server database administration
If a stored procedure is taking a table data type, how it looks?
What are window functions in sql server?
What is the stuff?
Explain the difference between primary keys and foreign keys?
Is ssrs support other database except ms sql server?
How does using a separate hard drive for several database objects improves performance right away?
how to avoid cursors? : Sql server database administration
Characterize join and name diverse sorts of joins?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas