TSQL Aggregate Functions
AVG
COUNT
MAX
MIN
SUM
TSQL String Functions
Charindex
Concat
Left
Len
Lower
Ltrim
Substring
Patindex
Replace
Right
Rtrim
Upper
TSQL Date and Time Data Types and Functions
@@DATEFIRST
CURRENT_TIMESTAMP
DATEADD
DATEDIFF
DATEFROMPARTS
DATENAME
DATEPART
DATETIMEFROMPARTS
DATETIME2FROMPARTS
DAY
EOMONTH
GETDATE()
GETUTCDATE()
ISDATE
MONTH
SMALLDATETIMEFROMPARTS
SWITCHOFFSET
SYSDATETIME
SYSDATETIMEOFFSET
SYSUTCDATETIME
TIMEFROMPARTS
TODATETIMEOFFSET
YEAR
TSQL System Functions
@@CONNECTIONS
@@ERROR
@@IDENTITY
@@ROWCOUNT
COALESCE
ERROR_LINE
ERROR_MESSAGE
ERROR_NUMBER
ERROR_PROCEDURE
ERROR_SEVERITY
ERROR_STATE
HOST_ID
HOST_NAME
ISNULL
ISNUMERIC
NULLIF
TSQL Security Functions
CURRENT_USER
ORIGINAL_LOGIN
SESSION_USER
SYSTEM_USER
USER_NAME
TSQL Metadata Functions
APP_NAME
DB_ID
DB_NAME
OBJECT_DEFINITION
OBJECT_ID
OBJECT_NAME
OBJECT_SCHEMA_NAME
SCHEMA_ID
SCHEMA_NAME
TSQL Configuration Functions
@@LOCK_TIMEOUT
@@MAX_CONNECTIONS
@@SERVERNAME
@@SERVICENAME
@@SPID
No comments:
Post a Comment