a stored procedure is a named collection of sql


A stored procedure is a named collection of SQL statements and procedural logic that is compiled, verified and kept in a server database. It is typically treated like any other database object. Stored procedures accept input parameters so that a one procedure can be used over the network by multiple clients using dissimilar input data. A single remote message triggers the implementation of a collection of stored SQL statements. The results is a reduction of network traffic and better performance.

 

Request for Solution File

Ask an Expert for Answer!!
Computer Networking: a stored procedure is a named collection of sql
Reference No:- TGS0272581

Expected delivery within 24 Hours