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

Chapter 20. Exploring Access Data Projec... > Examining Stored Procedures

Examining Stored Procedures

Access 2003’s project designer lets you create many common types of stored procedures without writing any T-SQL code. This new feature provides parity between Jet and SQL Server action queries, because you can create make-table, update, append values, and delete queries in the designer, instead of writing T-SQL in the text editor. (Access 2000’s project designer opened the text editor for new and existing stored procedures.) Like Jet UNION queries, you must write SQL Server UNION queries for views, functions, and stored procedures in the text editor. The project designer doesn’t have a Query, SQL Specific, Union menu choice.


NorthwindCS includes only parameterized SELECT stored procedures, which you create using the same process as that for parameterized in-line functions. Open one or more of the sample stored procedures in Design view to see the similarity between the grid and T-SQL statements for stored procedures. Simple parameterized in-line functions are updatable in Datasheet view; stored procedures—parameterized or not—aren’t updatable.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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