Using Pre and Post SQL commands
When we use databases to obtain data and/or save it, using the PRE and POST SQL options opens up a huge range of options for us, both for those who are not SQL programmers and for those who must provide access mechanisms to databases in a secure, governed way.
Common uses of this functionality include creating temporary tables and dropping or updating a table before running a query. With this, you also have the ability to run stored procedures (using the EXEC command) before and after the actual query as well.
One thing to highlight about this facility is that the stored procedures are executed entirely in the database engine.
On the other hand, when distributing database connections to our end users, it can be very useful to use custom queries in stored procedures, since they will surely go through certification processes before going to production, unlike custom queries, which, when executed, can throw errors and even break the database(s...
