• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. ADO.NET > Stored Procedures

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint