Following are functions related to SQL operations:
Loads and executes a Data Transformation Services package which initiates data transfer between OLE DB data sources. |
|
Appends a text string to the SQL buffer. |
|
Starts a database transaction. |
|
Commits a transaction to the database. |
|
Makes a connection to a database system for execution of SQL statements. |
|
Closes a database connection. |
|
Terminates an SQL query. |
|
Returns an error message from the SQL system. |
|
Executes an SQL query on a database. |
|
Gets information about the fields or columns selected in an SQL query. |
|
Gets field or column data from a database record. |
|
Gets information about a database connection. |
|
Gets the next database record from a SQL query. |
|
Gets the number of fields or columns that were returned by the last SQL statement. |
|
Gets the number of records that were modified in the last insert, update, or delete SQL statement. |
|
Rolls back (or cancels) the last database transaction. |
|
Sets a statement string in the SQL buffer. |
|
Turns off the debug trace. |
|
Turns on the debug trace. |
See Also