Konfiguration

@@DATEFIRST	@@OPTIONS
@@DBTS	@@REMSERVER
@@LANGID	@@SERVERNAME
@@LANGUAGE	@@SERVICENAME
@@LOCK_TIMEOUT	@@SPID
@@MAX_CONNECTIONS	@@TEXTSIZE
@@MAX_PRECISION	@@VERSION
@@NESTLEVEL	@@CONNECTIONS

Cursor

@@CURSOR_ROWS

@@FETCH_STATUS

Datum und Uhrzeit

DATEADD	GETDATE
DATEDIFF	GETUTCDATE
DATENAME	MONTH
DATEPART	YEAR
DAY

Mathematik

ABS	DEGREES
ACOS	RAND
ASIN	FLOOR
ATAN	LOG
ATN2	LOG10
CEILING	PI
COS	POWER
COT	RADIANS
TAN	SIN
SQRT	SIGN
SQUARE	ROUND

Metainformationen

COL_LENGTH	FILEGROUPPROPERTY
COL_NAME	FULLTEXTCATALOGPROPERTY
COLUMNPROPERTY	FULLTEXTSERVICEPROPERTY
DATABASEPROPERTY	FILEPROPERTY
DATABASEPROPERTYEX	INDEXKEY_PROPERTY
DB_ID	INDEXPROPERTY
DB_NAME	OBJECT_ID
FILE_ID	OBJECT_NAME
FILE_NAME	OBJECTPROPERTY
FILEGROUP_ID	@@PROCID
FILEGROUP_NAME	SQL_VARIANT_PROPERTY

Sicherheit

HAS_DBACCESS	IS_SRVROLEMEMBER
IS_MEMBER	SUSER_SID
USER	SUSER_SNAME
USER_ID

String

ASCII	NCHAR
CHAR	PATINDEX
CHARINDEX	REPLACE
DIFFERENCE	QUOTENAME
LEFT	REPLICATE
LEN	REVERSE
LOWER	RIGHT
LTRIM	RTRIM
UPPER	UNICODE
SUBSTRING	STUFF
STR	SPACE
SOUNDEX

System

APP_NAME	CASE
CAST	COALESCE
COLLATIONPROPERTY	CURRENT_TIMESTAMP
CURRENT_USER	GETANSINULL
@@ERROR	SESSION_USER
HOST_ID	SYSTEM_USER
IDENT_SEED	USER_NAME
ISNULL	HOST_NAME
CONVERT	IDENT_INCR
@@TRANSCOUNT	@@IDENTITY
STATS_DATE	ISDATE
SESSIONPROPERTY	ISNUMERIC
NEWID	NULLIF
PERMISSIONS	PARSENAME
ROWCOUNT_BIG	@@ROWCOUNT
SERVERPROPERTY	SCOPE_IDENTITY

Text und Bilder

PATINDEX	TEXTPTR
TEXTVALID