System#
This reference topic summarizes the statements for use with SQL (compatible with T-SQL). You can find all of the documented statements listed in the left-hand navigation.
- @@DATEFIRST
- @@MAX_PRECISION
- @@MICROSOFTVERSION
- @@OPTIONS
- @@SERVICENAME
- @@SPID
- @@TRANCOUNT
- @@VERSION
- APP_NAME
- ASSEMBLYPROPERTY
- COL_LENGTH
- COL_NAME
- COLLATIONNAME
- COLLATIONPROPERTY
- COLLATIONPROPERTYFROMID
- COLUMNPROPERTY
- CURRENT_USER
- DATABASE_PRINCIPAL_ID
- DATABASEPROPERTYEX
- DB_ID
- DB_NAME
- FULLTEXTCATALOGPROPERTY
- FULLTEXTSERVICEPROPERTY
- HAS_DBACCESS
- HAS_PERMS_BY_NAME
- HASHBYTES
- INDEXPROPERTY
- IS_MEMBER
- IS_ROLEMEMBER
- IS_SRVROLEMEMBER
- JSON_PATH
- LOAD_FILE
- NEWID
- OBJECT_ID
- OBJECT_NAME
- OBJECT_SCHEMA_NAME
- OBJECTPROPERTY
- OBJECTPROPERTYEX
- PARSENAME
- QUA_GET_INCREMENTAL_MARKER
- SCHEMA_ID
- SCHEMA_NAME
- SERVERPROPERTY
- SESSIONPROPERTY
- SUSER_SNAME
- SYSTEM_USER
- TYPE_ID
- TYPE_NAME
- TYPEPROPERTY
- USER_NAME