The American National Standards Institute, which made SQL a standard in 1986, a year before ISO did. Its standard types, for example INT, DECIMAL and VARCHAR, explain why SQL looks much the same from one vendor to another, even though each has its own dialect.
Also called American National Standards Institute.
Read more: Microsoft Learn
In the Ultra Transcenders books
DP-900DP-750DP-600DP-700MD-102DP-800
Each book explains ANSI in context, with comparison tables and the common traps.
Terms in this definition
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- Standard deployment type
A Foundry deployment type billed per token that keeps processing of prompts and responses inside the Azure geography of the resource, meeting data residency needs at lower volumes.
- ISO
The International Organization for Standardization. SQL became an ISO standard in 1987, twelve months after ANSI adopted it.
- DECIMAL
Use
DECIMAL(p,s)for money or any figure where floating-point rounding would be wrong. Precisionpcan be 1 to 38 and is 10 if left out; scalesis 0 if left out. - VARCHAR
Stores text of varying length, capped at a declared maximum, for example VARCHAR(50); it is part of standard SQL.
Related terms
- Databricks SQL
Brings warehousing to an Azure Databricks lakehouse. ANSI SQL runs against Delta tables using SQL warehouses, compute tuned for heavy query concurrency and BI tools.