12 – Stored Procedures

In this post I will be discussing Stored Procedures, how to create them and the benefits of using them.

Stored Procedures in SQL Server are similar to sub procedures in MS Access. We often have code that needs to be called in more than one location and rather than duplicate the code, it is preferable to keep it in a stored procedure and be able to call it from multiple locations. We are going to use the HotelBookingsDB to provide a solid working example of this.

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!