Transact-SQL reference#
Querona speaks Transact-SQL, the SQL Server query language. Tools and applications connect to Querona as if it were SQL Server and issue T-SQL. This reference describes the T-SQL surface Querona supports.
SQL Server compatibility#
Querona exposes a SQL Server–compatible endpoint and emulates the T-SQL surface, so your existing T-SQL, drivers and tools carry over. For what is emulated, see SQL Server compatibility.
Tools and clients#
Any SQL Server client works against Querona — SQL Server Management Studio (SSMS), the ADO.Net, ODBC, JDBC and OLEDB drivers, and BI tools such as Power BI — pointed at Querona as if it were SQL Server. See Client Connectivity.
Reference topics#
Statements and Queries — Querona is read-first, so
SELECTis the everyday statement.Functions and User-defined functions — built-in and user-defined functions.
Data types and Spatial Types — the supported data types, grouped by category.
Collations — how character data is sorted, compared and encoded.
Language Elements — operators, expressions, control-of-flow and the other language building blocks.
System views#
System catalog views, dynamic management views, system functions, information-schema views, system stored procedures and system tables are documented elsewhere in the Reference section.
Syntax conventions#
The notation used in the syntax descriptions, and the rules for multipart object names, are described in Syntax conventions.