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 the advantages of sql stored procedure?
can we have a nested transaction? : Sql server database administration
What is the xml datatype?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Is it safe to delete log files?
Call by value and call by reference in procedure and function, with NOCOPY.
How to insert stored procedure result into temporary table?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is amo? : sql server analysis services, ssas
Difference between aggregate functions of sql?
Explain what is row_number function?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Scalability, Availability, Integration with internet, etc.)?
What is explicit cursors?