Tag: Stored Procedures

Drawbacks of Using Stored Procedures to Compute Data

SQL focuses on structured data computations, yet it lacks procedural control syntax for handling procedure-oriented computations. The SQL-based Stored procedure (SP) is created to make up for this absence by supporting the much-needed syntax. SP also features a series of merits, including code encapsulation, injection prevention and dynamic syntax. In practical use, however, its demerits are unignorable.

Is There Any Alternative to Stored Procedures?

There has been a long-standing debate about the stored procedure’s weaknesses. Now let’s again look at its disadvantages.

on-migratable continue reading →

Goodbye, Stored Procedures – the Love/Hate Thing

The debate on the advantages and disadvantages of stored procedures has long existed. Here again, we will examine them one by one.

Pros

Of course, stored procedures have their merits because there is no shortage of applications. continue reading →

Beyond ORM and Stored Procedures

Business logic consists of database read & write, structured data computation, and procedural control. The first two parts are what SQL was designed for and thus easy to handle. But SQL lacks procedural control statements (loop and judgement), it cannot achieve the whole business logic on its own. In order to address this issue, database vendors invented a new language based on SQL and procedural control statements. That is stored procedure.

The stored procedure has more complete functionalities to achieve business logics independently

The language combines SQL and procedural control statements. Their cooperation gives the stored procedure complete functionalities to implement the whole business logic. For example: continue reading →