Stored Procedures using Input Parameters
- Tauseef.M
Well guys, in my previous articles I have given a preliminary description about the Stored Procedure and also had given a word that I will be dealing with it in more detail in my upcoming articles. As the saying goes “Once a word has been allowed to escape, it cannot be recalled”, and so I am back here with advanced stored procedure concepts.
Insertion using Stored Procedure’s Input Parameters
Fig (a)
Now let’s create a Stored Procedure for insertion. Open a new Query window and type the below stored procedure. 
Stored procedure named usp_insert gets created into database.
Yeah!! The below syntax is used for executing the above created stored procedure.
Updating table - Stored Procedure using Input Parameters
Let’s have a glance over the fig (a) above. Now we are going to use the same table for creating the stored procedure for updating the table.
Portray the same as below in a new Query Window.
Stored procedure named usp_Update gets created into database.
Execute Stored Procedure??
Before executing let us see the records inside the table tblEmployee.
Deleting Records - Stored Procedure using Input Parameters
Let’s create a stored procedure named usp_Delete
Stored Procedure using Output variables will be explained in my upcoming articles!!
(The author, Tauseef.M, is a Software Engineer at Binary Spectrum).