I have few queries regarding the use of Stored Procedures, Functions and Triggers in an RDBMS. (1) When to use Stored Procedure? Writing an INSERT query in a Stored Procedure is better or firing it from the application level? (2) Can a Trigger call a Stored Procedure? (3) What type of code must reside in application and what type in RDBMS? (4) Is it faster to work at application level or at the database level? ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
