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.
@@IDENTITY	Returns the last identity value generated by an INSERT in the current session.
@@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.
@@ROWCOUNT	Returns the number of rows affected by the most recently completed statement.
@@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.
BINARY_CHECKSUM	Returns a checksum computed over one or more expressions, folding string arguments case-sensitively.
CHECKSUM	Returns a checksum computed over one or more expressions, folding string arguments case-insensitively.
COL_LENGTH	Returns the defined length, in bytes, of a column.
DATALENGTH	Returns the number of bytes used to represent an expression.
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.
IDENT_CURRENT	Not supported: raises an error, since its value is the live identity counter on the backing source.
IDENT_INCR	Returns the declared increment of a table’s identity column.
IDENT_SEED	Returns the declared seed of a table’s identity column.
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.
ROWCOUNT_BIG	Returns the number of rows affected by the most recently completed statement, as a bigint.
SCHEMA_ID	Returns the schema ID associated with a schema name.
SCHEMA_NAME	Returns the schema name associated with a schema ID.
SCOPE_IDENTITY	Returns the last identity value generated by an INSERT in the current session and scope.
SERVERPROPERTY	Returns property information about the server instance.
SESSIONPROPERTY	Returns the SET options settings of a session.
SUSER_SID	Returns the security identification number (SID) for the specified login name.
SUSER_SNAME	Returns the login name associated with a security identification number (SID).
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.