Why must create store procedure? How it's work?
At the first time I really did't see how was store procedure help me, because I could create code or query by use SQL or MySQL format but after I know about procedure that sound pretty cool!
1. Safe performance of database because even if you have many jobs must query or updated in same time, store procedure can help and better then use query by an other code
2. Easy to use and create
OKEY! let's create
STEP-1Click right at "Store Procedure" menu in your database list, then go to "New" and click on "Store Procedure"
STEP-2
You will see procedure area to build the code. The system will generated default value as details below.
STEP-3
In line "CREATE PROCEDURE [dbo].[your_store_procedure_name]" you have to changed to your procedure name, Then click on "Execute" for create new procedure. After you refreshed your database, you will see the new procedure name appears as you just created.
STEP-4
Close window on STEP-3 and click right on "Procedure_your_name" and select "Modify" to programming.
STEP-5
A simple code to delete data in period as selected data.
Beware, Please arrange parameters were match with your selection data.
Download Example Code Here
