Home
Concept
Overview
Data virtualization
Data encryption
Query retargeting
User Manual
About User Manual
Client connectivity
Overview
Excel
PowerBI
Tableau
Connections
Overview
Add connection
Manage connections
Databases
Overview
Add database
Manage databases
Schemas
Manage schemas
Tables
Overview
Add table
Manage tables
Primary and Foreign Keys
Primary and Foreign Keys
Views
Overview
Add view
Manage views
Indexes
Indexes
Bulk operations
Overview
Management tasks
Overview
Business terms
Assign business term
Search
Search screen
Query
Query screen
Reference Guide
Data providers
Overview
CSV/TSV
Kafka
JDBC
MySql
Oracle
SAP
SAP HANA
SQL in Lyftron
SQL Language Elements
Overview
SQL Language Elements
Keywords
Identifier
Literals
Operators
Expressions
Predicates
SQL Data Types
Overview
Numeric Data Types
Date and Time Types
String Types
Other Types
Statements
Overview
CREATE DATABASE
Functions
Overview
Aggregate
APPROX_COUNT_DISTINCT
AVG
CHECKSUM_AGG
COUNT_BIG
COUNT
GROUPING
GROUPING_ID
KURTOSIS
MAX
MIN
STDEV
STDEVP
SKEWNESS
SUM
VAR
VARP
Analytical
CUME_DIST
FIRST_VALUE
LAG
LAST_VALUE
LEAD
PERCENTILE_CONT
PERCENTILE_DISC
PERCENT_RANK
Azure
DETECT_FACES
USER_TO_ITEM_RECOMMENDATION
Date & time
DATEADD
DATEDIFF
DATEFROMPARTS
DATENAME
DATEPART
DATETIME2FROMPARTS
DATETIMEFROMPARTS
DAY
EOMONTH
GETDATE
GETUTCDATE
ISDATE
MONTH
SMALLDATETIMEFROMPARTS
SYSDATETIME
SYSUTCDATETIME
TIMEFROMPARTS
YEAR
Expression
COALESCE
IIF
ISNULL
NULLIF
Math
ABS
ACOS
ASIN
ATAN
ATN2
CEILING
COS
COT
DEGREES
EXP
FLOOR
LOG10
LOG
PI
POWER
RADIANS
RAND
ROUND
SIGN
SIN
SQRT
SQUARE
TAN
Metadata
QUA_PARTITION_HINT
Ranking
DENSE_RANK
NTILE
RANK
ROW_NUMBER
String
ASCII
CHAR
CHARINDEX
CONCAT
FORMAT
LEFT
LEN
LEVENSHTEIN
LOWER
LTRIM
NCHAR
PATINDEX
QUOTENAME
REPLACE
REPLICATE
REVERSE
RIGHT
RTRIM
SPACE
SPLIT
STR
STUFF
SUBSTRING
UNICODE
UPPER
System
@@DATEFIRST
@@MAX_PRECISION
@@MICROSOFTVERSION
@@OPTIONS
@@SERVICENAME
@@SPID
@@TRANCOUNT
@@VERSION
APP_NAME
ASSEMBLYPROPERTY
COLLATIONNAME
COLLATIONPROPERTY
COLLATIONPROPERTYFROMID
COL_LENGTH
COL_NAME
COLUMNPROPERTY
CURRENT_USER
DATABASE_PRINCIPAL_ID
DATABASEPROPERTYEX
DB_ID
DB_NAME
FULLTEXTCATALOGPROPERTY
FULLTEXTSERVICEPROPERTY
HAS_DBACCESS
HASHBYTES
HAS_PERMS_BY_NAME
INDEXPROPERTY
IS_MEMBER
IS_ROLEMEMBER
IS_SRVROLEMEMBER
JSON_PATH
LOAD_FILE
NEWID
OBJECT_ID
OBJECT_NAME
OBJECTPROPERTYEX
OBJECTPROPERTY
OBJECT_SCHEMA_NAME
PARSENAME
QUA_GET_INCREMENTAL_MARKER
SCHEMA_ID
SCHEMA_NAME
SERVERPROPERTY
SESSIONPROPERTY
SUSER_SNAME
SYSTEM_USER
TYPE_ID
TYPE_NAME
TYPEPROPERTY
USER_NAME
Tabular
FN_BUILTIN_PERMISSIONS
FN_HELPCOLLATIONS
Data pseudonymization
QUA_SHUFFLE
QUA_DESHUFFLE
Stored procedures
About stored procedures
Overview
Administrative
lyft_flush_plan_cache
lyft_run_garbage_collection
lyft_set_default_federator
Cache management
lyft_create_view_copy
lyft_evict_spark_inmem_cached_table
lyft_full_load_cached_view_copy
lyft_full_load_view_copy
lyft_incremental_insert
lyft_incremental_load_cached_view_copy
lyft_invalidate_spark_cached_table
lyft_populate_cached_table
lyft_refresh_view
lyft_set_reload_mode
lyft_set_view_cache_mode
lyft_set_view_copy_status
lyft_set_incremental_marker
lyft_set_incremental_marker_column
lyft_switch_view_copy
lyft_trim_view_copy
Connection management
sp_addlinkedserver
sp_addlinkedsrvlogin
sp_dropserver
sp_testlinkedserver
sp_updatelinkedserver
Diagnostics
lyft_set_logging_level
lyft_help_jobs
Job management
sp_add_job
sp_add_jobstep
sp_add_schedule
sp_attach_schedule
sp_detach_schedule
sp_start_job
sp_update_job
sp_update_jobstep
sp_update_schedule
sp_delete_job
sp_delete_jobstep
sp_delete_schedule
Utility
lyft_execute_provider_sql_on_connection
lyft_update_object_statistics
lyft_update_row_count_object_statistics
Metadata management
lyft_get_partitioning_schema
lyft_set_partitioning_schema
sp_import_metadata
sp_generate_views
Spark management
lyft_spark_force_become_active
lyft_spark_force_become_standby
lyft_spark_instance_kill
lyft_spark_instance_start
lyft_spark_instance_stop
lyft_spark_release
lyft_spark_stop_driver
Non-standard views
Overview
lyft-functions
lyft-materialized-views
lyft-provider-tables
lyft-recent-statements
Caching and partitioning
Monitoring
Overview
Active statements
Broken views
Client connections
Execution plan cache
Running jobs
Statement history
Administrators Guide
Administration Overview
Access Rights
Business terms
Engine configuration
Jobs and Schedules
Logging
Spark management
Overview
Spark database migration
SQL dialects
Users and Roles
Installation Guide
Getting Started
Requirements
Components
Prerequisites
Installation prerequisites
Installation of SQL Server engine
Installation
Manual installation of metabases
Configuration
Upgrade
Lyftron™ product documentation
Docs
»
Reference Guide »
SQL Language Elements »
Overview
SQL Language Elements
This chapter presents detailed descriptions of the language elements of Lyftron.
« Previous
Next »