Welcome Guest, Not a member yet? Register   Sign In
Which is best Query builder vs Stored Procedure

Basically I always use stored procedure for everything even it is a single query. I want to know the Pros and Cons of both methods

Bottom line: Portability ... Not all DBMS support stored Procs ... and when they do, it's in a different manner.
SProcs need to be managed and maintain some where - and then the scripts need to be executed for any updates.

Builders ... it's self contained and you just have to upload the new file for changes. It also makes it trivial to move from one db to another, or from one dbms to another ...

Theme © iAndrew 2016 - Forum software by © MyBB