Welcome to ciysys blog

Benefits of using stored procedure

Published on: 1st Oct 2012

Updated on: 18th May 2021

Overview

Starting from my favorite programming language, Visual Basic 6 (VB6) (that was in 1997), I've been thinking where is the best place to implement the "business rule". With VB6, you may implement business rules very quickly. But, if you made a mistake that caused a bug, then, you will have to recompile the program and update all the workstations. It's quite tedious.

After many years of moving the business rules in between the programming language and database, in 2012, I have decided the best place for the business rule should be in the stored procedure and not in SQL trigger.

Why stored procedure

A stored procedure can handle all these operations: SELECT, INSERT, UPDATE and DELETE. In fact, you can do more than that. Benefits of using the stored procedure,

What have we achieved with stored procedure

Added on: 18th May 2021

Starting from 2008, we have focused on web application development rather than desktop application development. With the move to use stored procedure, we have achieved the following

A little bit of my history: we have focused on C# since 2008, and we put more focus on Node.js on Ubuntu since 2020.

Jump to #MSSQL blog

Author

Lau Hon Wan, software developer.