A Stored Procedure is a group of Sql statements which are created and stored in the database and this procedure will accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored Procedure will reduce network traffic and increase the performance. In the future if we modify stored procedure all the clients will get the updated Stored Procedure. It based on Structured Query Language (SQL) statements with an assigned name that"s stored in the database in compiled form so that it can be shared by a number of programs and improve performance. In the web development many tasks are implemented as a series of SQL statements. Conditional logic applied to the results of the first SQL statements and these conditional logic are written into a stored procedure, they become part of a single execution plan on the server.