System

System functions return information about values, objects and settings in Querona — server and session properties, object and column metadata, and similar.

Function	Description
@@DATEFIRST	Returns the current value, for a session, of SET DATEFIRST.
@@MAX_PRECISION	Returns the precision level used by decimal and numeric data types as currently set in Querona.
@@MICROSOFTVERSION	Returns version information of SQL Server which Querona is compatible with.
@@OPTIONS	Returns information about the current SET options.
@@SERVICENAME	Returns the name of the registry key under which Querona is running. @@SERVICENAME returns ‘SQL2012’.
@@SPID	Returns the session ID of the current user process.
@@TRANCOUNT	Returns the number of BEGIN TRANSACTION statements that have occurred on the current connection.
@@VERSION	Returns system and build information for the current installation of Querona.
APP_NAME	Returns the application name for the current session if set by the application.
ASSEMBLYPROPERTY	Returns information about a property of an assembly.
COL_LENGTH	Returns the defined length, in bytes, of a column.
COL_NAME	Returns the name of a column from a specified corresponding table identification number and column identification number.
COLLATIONNAME	Returns collation name by collation ID.
COLLATIONPROPERTY	Returns the property of a specified collation.
COLLATIONPROPERTYFROMID	Returns the property of a specified collation.
COLUMNPROPERTY	Returns information about a column or parameter.
CURRENT_USER	Returns the name of the current user. This function is equivalent to USER_NAME.
DATABASE_PRINCIPAL_ID	Returns the ID number of a principal in the current database.
DATABASEPROPERTYEX	Returns the current setting of the specified database option or property for the specified database in Querona.
DB_ID	Returns the database identification (ID) number.
DB_NAME	Returns the database name.
FULLTEXTCATALOGPROPERTY	Returns information about full-text catalog properties.
FULLTEXTSERVICEPROPERTY	Returns information related to the properties of the Full-Text Engine.
HAS_DBACCESS	Returns information about whether the user has access to the specified database.
HAS_PERMS_BY_NAME	Evaluates the effective permission of the current user on a securable.
HASHBYTES	Returns the MD2, MD4, MD5, SHA, SHA1, or SHA2 hash of its input.
INDEXPROPERTY	Returns the named index or statistics property value of a specified table identification number, index or statistics name, and property name. Returns NULL for XML indexes.
IS_MEMBER	Indicates whether the current user is a member of the specified Microsoft Windows group or Querona database role.
IS_ROLEMEMBER	Indicates whether a specified database principle is a member of the specified database role.
IS_SRVROLEMEMBER	Indicates whether a SQL Server login is a member of the specified server role.
JSON_PATH	Returns the content of the item queried by XPath expression.
LOAD_FILE	Loads file content in bytes.
NEWID	Creates a unique value of type uniqueidentifier.
OBJECT_ID	Returns the database object identification number of a schema-scoped object.
OBJECT_NAME	Returns the database object name for schema-scoped objects.
OBJECT_SCHEMA_NAME	Returns the database schema name for schema-scoped objects.
OBJECTPROPERTY	Returns information about schema-scoped objects in the current database. OBJECTPROPERTY cannot be used for objects that are not schema-scoped, such as data definition language (DDL) triggers and event notifications. |
OBJECTPROPERTYEX	Returns information about schema-scoped objects in the current database. OBJECTPROPERTYEX cannot be used for objects that are not schema-scoped, such as data definition language (DDL) triggers and event notifications. |
PARSENAME	Returns the specified part of an object name. The parts of an object that can be retrieved are the object name, owner name, database name, and server name.
QUA_GET_INCREMENTAL_MARKER	Returns a marker value for a last updated row in a table.
SCHEMA_ID	Returns the schema ID associated with a schema name.
SCHEMA_NAME	Returns the schema name associated with a schema ID.
SERVERPROPERTY	Returns property information about the server instance.
SESSIONPROPERTY	Returns the SET options settings of a session.
SUSER_SNAME	Returns the login identification name of the user.
SYSTEM_USER	Allows a system-supplied value for the current login to be inserted into a table when no default value is specified.
TYPE_ID	Returns the ID for a specified data type name.
TYPE_NAME	Returns the unqualified type name of a specified type ID.
TYPEPROPERTY	Returns information about a data type.
USER_NAME	Returns a database user name from a specified identification number.