Nonrowreturning Queries

Queries that do not return records, such as Action queries or Data Definition Language (DDL) queries, are known as non-row-returning queries.

• Action queries are Data Manipulation Language (DML) queries that perform bulk operations on a set of records. They allow you to add, update, or delete records.

• The DDL queries are used for creating database objects and altering the structure of a database.

Use the ADOX Procedure object to work with queries that don't return records. All Procedure objects are contained in the Procedures collection of the ADOX Catalog object. To save these types of queries in a database, append the ADO Command object to the ADOX Procedures collection.

0 0

Post a comment