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

Chapter 21. Moving from Jet Queries to T... > Writing Action Queries and Stored Pr...

Writing Action Queries and Stored Procedures

Data Manipulation Language (DML) commands are implemented by action queries: append, update, delete, and make-table. Jet uses QueryDefs for action queries; ADP require stored procedures or functions to support INSERT, UPDATE, DELETE, and SELECT...INTO statements. This section shows the standard syntax for each type of action query, which is identical in Jet SQL and T-SQL.

Append queries use the following syntax:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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