Stored Procedures
One of the great advantages of Microsoft SQL Server and Oracle databases are stored procedures. Unfortunately, Microsoft Access doesn’t support them. The simple explanation is that they are just Transact SQL statements that are stored in the database. This makes compartmentalizing function that is associated with the database, in the database a bit more real. But there is more to it than that.
Stored procedures allow true logical function before data is ever passed across the connection to ASP.NET pages. You can perform logical functions—such as branching—right within SQL Server, so you are really only delivering data through ADO.NET that you need.
Stored procedures also allow multi-part interaction with your database, as well. ...
Get ASP.NET for Web Designers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
