S tored Procedure is m ost popular database object . A stored procedure in SQL Server is a group of one or more Transact-SQL statements . Procedures resemble constructs in other programming languages because they can: ü Allow input parameters and return multiple values in the form of output parameters to the calling program. ü Contain programming statements that perform operations in the database. Can calling other procedure, functions ü Return a status value to a calling program to indicate success or failure (and the reason for failure). Benefits of Using Stored Procedures: ü Reduced server/client network traffic: A procedure contain a batch of sql statement, even execute other procedure, This can significantly reduce network traffic between the server and client because only the call to execute the procedure is sent across the network. ü Stronger security: Store procedure has stronger permission, administrator has grant option to g