Lyftrondata supports SQL that is compatible with Transact-SQL. This document describes all supported statements, functions, data types and stored procedures.
Functions
Lyftrondata ships with a concrete set of supported functions. They are based on SQL Server functions thus a name and behavior are the same in most cases. Using this reference you can find all detailed descriptions and examples about the built-in functions.
Click Functions for more details
Data Types
Lyftrondata Supports many different data types.
Click Data Types for more details
Queries
Query screen is a place in the administration portal where the user can issue SQL statements to Lyftrondata and view execution results. Query screen can be accessed by selecting "QUERY" from the main menu.
Click on Queries for more details
SQL Language Elements
This section presents detailed descriptions of the SQL language elements.
Click SQL Language Elements for more details
Stored Procedures
Apart from emulating SQL Server's stored procedures, Lyftrondata introduces some of its own. All of them start with lyft_ prefix to be easily distinguished from regular SQL Server stored procedures.
Click Stored Procedures for more details
Statements
This reference section summarizes the statements for use with SQL (compatible with T-SQL).
Click Statements for more details
Transact- SQL Syntax Conventions
Lyftrondata supports SQL that is compatible with Transact-SQL.
Click Transact-SQL Syntax Conventions for more details