O'Reilly logo

ASP.NET for Web Designers by Peter Ladka

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required