siehe auch: Transact-SQL Funktionen nach Kategorien
@@CONNECTIONS
@@CURSOR_ROWS
@@DATEFIRST
@@DBTS
@@ERROR
@@FETCH_STATUS
@@IDENTITY
@@LANGID
@@LANGUAGE
@@LOCK_TIMEOUT
@@MAX_CONNECTIONS
@@MAX_PRECISION
@@NESTLEVEL
@@OPTIONS
@@PROCID
@@REMSERVER
@@ROWCOUNT
@@SERVERNAME
@@SERVICENAME
@@SPID
@@TEXTSIZE
@@TRANCOUNT
@@VERSION
ABS
ACOS
APP_NAME
ASCII
ASIN
ATAN
ATAN2
CASE
CAST
CEILING
CHAR
CHARINDEX
COALESCE
COL_LENGTH
COL_NAME
COLLATIONPROPERTY
COLUMNPROPERTY
CONVERT
COS
COT
CURRENT_TIMESTAMP
CURRENT_USER
DATABASEPROPERTY
DATABASEPROPERTYEX
DATALENGTH
DATEADD
DATEDIFF
DATENAME
DATEPART
DAY
DB_ID
DB_NAME
DEGREES
DIFFERENCE
EXP
FILE_ID
FILE_NAME
FILEGROUP_ID
FILEGROUP_NAME
FILEGROUPPROPERTY
FILEPROPERTY
FLOOR
FULLTEXTCATALOGPROPERTY
FULLTEXTSERVICEPROPERTY
GETANSINULL
GETDATE
GETUTCDATE
HAS_DBACCESS
HOST_ID
HOST_NAME
IDENT_INCR
IDENT_SEED
INDEX_COL
INDEXKEY_PROPERTY
INDEXPROPERTY
IS_MEMBER
IS_SRVROLEMEMBER
ISDATE
ISNULL
ISNUMERIC
LEFT
LEN
LOG
LOG10
LOWER
LTRIM
MONTH
NCHAR
NEWID
NULLIF
OBJECT_ID
OBJECT_NAME
OBJECTPROPERTY
PARSENAME
PATINDEX
PERMISSIONS
PI
POWER
QUOTENAME
RADIANS
RAND
REPLACE
REPLICATE
REVERSE
RIGHT
ROUND
ROWCOUNT_BIG
RTRIM
SCOPE_IDENTITY
SERVERPROPERTY
SESSION_USER
SESSIONPROPERTY
SIGN
SIN
SOUNDEX
SPACE
SQL_VARIANT_PROPERTY
SQRT
SQUARE
STATS_DATE
STR
STUFF
SUBSTRING
SUSER_ID
SUSER_NAME
SUSER_SID
SUSER_SNAME
SYSTEM_USER
TAN
TEXTPTR
TEXTVALID
TYPEPROPERTY
UNICODE
UPPER
USER
USER_ID
USER_NAME
YEAR
Sehr schöne Site zum Thema "Data Transformation Services"