A stored procedure that encapsulates those many SQL statementswould enable the work to be done in one transmission.A stored procedure is a dynamically linked library (DLL) or program that runs onthe server and is called by the database engine in response to a call by a client.