Fundamental Microsoft SQL statements
- Last UpdatedApr 24, 2025
- 1 minute read
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:
|
Option |
Attribute |
Comment |
|---|---|---|
|
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 |