#create procedure

Create Stored Procedures – Your First Walk Through

I recently put together a lesson on how to create stored procedures.  It is part of my Stored Procedures Unpacked course.  When you create stored procedures, you can encapsulate logic securely, while allowing client program an easy way to execute it.

I put this walk through together so that you’ll see how the whole process works.  I think, that before we dive too deeply into how to create…

After reading this article you will understand the benefits of stored procedures and how to create and execute them.

All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters.  You can get started using these free tools using my Introduction to Stored Procedures

Guide Getting Started Using SQL Server.

What is…

Drop all tables from MySQL database

From time to time I stumble over the case, that I have to drop all tables from a MySQL database. In phpMyAdminor other GUI-based tools – in general – you only have the possibility to drop the whole database. But then you have to recreate it from the scratch.  Or you have to click-drop each table separately.  Another common – but not that clever – practise is it to delete each table by a…