Hi. Â As I entered in the topic, I work for a company in Maryland. Â I have considerable experience working with Microsoft Access, but not much with SQL Server. Â Â I have a question on SQL Server: Â What is a stored procedure? Â Is this like a module in Microsoft Access?
JP
Thanks for your question JP.
A stored procedure is a bit different from a module in Access. Specifically it is a named group of SQL statements that have been previously created and stored in the server database. Stored procedures normally accept input parameters so that a single procedure can be used over the network by several clients using different input data. And when the code of the procedure is modified, all clients automatically get the new version. Stored procedures reduce network traffic and improve performance. They are good programming technique. Stored procedures can also be used to help ensure the integrity of databases.