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

Chapter 20. Exploring Access Data Projec... > Taking Advantage of In-line Function...

Taking Advantage of In-line Functions

SQL Server 2000’s in-line functions let you emulate Jet’s parameterized queries. Views don’t accept parameters, but you can choose between table-returning functions and stored procedures. Functions and stored procedures accept one or more input parameters, which can emulate Jet parameters. One of the advantages of a parameterized function is that it can substitute for a table name in the FROM clause of a SELECT query.

→ To review Jet parameterized queries, see “Designing Parameter Queries,” p. 440.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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