Microsoft SQL Engine
- Last UpdatedNov 02, 2023
- 1 minute read
Key Concepts
-
Used to access the RealTime database (RTDB) and enumerations (EnumDB)
-
Specific syntax required to view, create, update and delete database table records
-
Default schema is in Native format; but ANSI and ODBC schema types are available for backwards compatibility
-
Logs events for queries which modify data
-
Supports execution of stored procedures
Key Tasks
-
Starting the Interactive Structured Query Language (ISQL) Tool
-
Viewing Table Schema
-
Configuring Additional BLT Components
-
Troubleshooting BLT Components
Related Links
- Start the Interactive SQL (ISQL) tool
- Microsoft SQL Engine default schema
- Create a custom Data Source Name (DSN)
- Microsoft SQL Engine connection string
- View table schema
- View table column names and types
- Microsoft SQL Engine event logging
- Microsoft SQL Engine stored procedures
- Configure additional Business Logic Tier (BLT) components
- Troubleshooting Business Logic Tier (BLT) errors
- Microsoft SQL statements