Microsoft SQL statements
- Last UpdatedApr 24, 2025
- 1 minute read
Progress DataDirect OpenAccess is a third-party toolkit that is used to support Microsoft SQL access to the RealTime database (RTDB). The OpenAccess Software Development Kit (SDK) implements a large portion of entry-level Microsoft SQL and Microsoft SQL features. In addition to statements supported by OpenAccess, AVEVA Enterprise SCADA supports additional stored procedures.
Fundamental Microsoft SQL Statements
The Progress DataDirect OpenAccess Software Development Kit (SDK) implements a large portion of Microsoft SQL:
-
Entry-level Microsoft SQL, as defined in the X3.135-1995 "Database Language SQL" specification.
-
Microsoft SQL features from ANSI SQL99.
Most Microsoft SQL commands are described in the DataDirect OpenAccess SDK SQL Reference available at: https://www.progress.com/open-access/resources/documentation/readme-file. The following table outlines which statements are supported:
|
Statement Type |
Examples |
Supported |
|---|---|---|
|
Data Manipulation Language |
Select, Insert, Call |
Yes |
|
Transaction Control Statements |
Commit, Rollback |
No |
|
Data Definition Language |
Alter Table, Create Index |
No |
|
Data Control Language |
Create Roll, Create User |
No |