T-SQL o SQL Server
Functions
- General functions
- EXECUTE
- RAISERROR
- CHECKPOINT
- KILL
- RECONFIGURE
- SHUTDOWN
- NULL & UNKNOWN
- USE
- GO
- Aggregate functions
- AVG
- CHECKSUM_AGG
- COUNT
- GROUPING
- MAX
- MIN
- STDEV
- SUM
- VAR
- Conversion functions
- CAST & CONVERT
- PARSE
- TRY_CAST
- TRY_CONVERT
- TRY_PARSE
- Date and time functions
- DATEADD
- DATENAME
- DATEDIFF
- GETDATE
- YEAR
- MONTH
- DAY
- DATEPART
- FORMAT
- Mathematical functions
- ABS
- ATAN
- CEILING FLOOR
- COS ACOS SIN ASIN TAN ATAN
- COT
- DEGREES
- EXP
- LOG
- PI
- POWER
- RADIANS
- RAND
- ROUND
- SIGN
- SQRT
- SQUARE
- Logical functions
- CHOOSE
- GREATEST
- IIF
- LEAST
- Security functions
- CURRENT_USER
- IS_MEMBER
- PERMISSIONS
- SESSION_USER
- SESSIONPROPERTY
- SYSTEM_USER
- USER
- USER_ID
- USER_NAME
- String functions
- ASCII
- CHAR
- CHARINDEX
- CONCAT
- DIFFERENCE
- FORMAT
- LEFT, RIGHT
- LEN
- LOWER, UPPER
- NCHAR
- PATINDEX
- QUOTENAME
- REPLACE
- REPLICATE
- REVERSE
- SOUNDEX
- SPACE
- STR
- STRING_AGG
- STRING_ESCAPE
- STUFF
- SUBSTRING
- TRANSLATE
- TRIM, LTRIM, RTRIM
- UNICODE
- System fuctions
- CHECKSUM
- COMPRESS
- DECOMPRESS
- ERROR_LINE
- ERROR_MESSAGE
- ERROR_NUMBER
- ERROR_PROCEDURE
- ERROR_SEVERITY
- ERROR_STATE
- FORMATMESSAGE
- GETANSINULL
- HOST_ID
- HOST_NAME
- ISNULL
- ISNUMERIC
- NEWID
Language elements
- General
- Comment (— or /* */)
- EXECUTE
- RAISERROR
- CHECKPOINT
- KILL
- RECONFIGURE
- SHUTDOWN
- NULL & UNKNOWN
- USE
- GO
- Controles de flujo
- BEGIN…END
- BREAK
- CONTINUE
- ELSE (IF…ELSE)
- END (BEGIN…END)
- GOTO
- IF…ELSE
- RETURN
- THROW
- TRY…CATCH
- WAITFOR
- WHILE
- Cursors
- CLOSE
- DEALLOCATE
- DECLARE CURSOR
- FETCH
- OPEN
- Expressions
- CASE
- COALESCE
- NULLIF
- Operators
- Arithmetic
- +, +=
- -. -=
- *, *=
- /, /=
- %, %=
- Bit
- &, &=
- |, |=
- ^, ^=
- ~
- Comparator
- =
- >, >=
- <, ⇐
- != or <>
- Logical
- ALL
- AND
- ANY
- BETWEEN
- EXISTS
- IN
- LIKE
- NOT
- OR
- SOME | ANY
- Relational operators
- GENERATE_SERIES
- OPENDATASOURCE
- OPENJSON
- OPENQUERY
- OPENROWSET
- OPENXML
- PREDICT
- STRING_SPLIT
- String
- =
- +
- +=
- %
- [ ]
- [^]
- _
- Arithmetic
- Transactions
- BEGIN DISTRIBUTED TRANSACTION
- BEGIN TRANSACTION
- COMMIT TRANSACTION
- COMMIT WORK
- ROLLBACK TRANSACTION
- ROLLBACK WORK
- SAVE TRANSACTION
- Variables
- SET @local_variable
- SELECT @local_variable
- DECLARE @local_variable
Queries
- SELECT
- SELECT - FOR Clause
- SELECT - GROUP BY
- SELECT - WINDOW Clause
- SELECT - HAVING
- SELECT - INTO Clause
- SELECT - ORDER BY Clause
- SELECT - OVER Clause
- FROM plus JOIN APPLY
- WHERE
- CONTAINS
- IS [NOT] DISTINCT FROM
- IS [NOT] NULL
- Logical functions
- BETWEEN
- EXISTS
- IN
- LIKE
Statements
- General
- ENABLE / DISABLE TRIGGER
- DELETE
- INSERT
- UPDATE
- MERGE
- Backup & restore
- ALTER, CREATE, DROP
- DATABASE
- FUNCTION
- INDEX
- PROCEDURE
- SERVICE
- TABLE
- TRIGGER
- USER
- VIEW
- Permissions
- DENY
- GRANT
- REVOKE
- Service Broker
- BEGIN CONVERSATION TIMER
- BEGIN DIALOG CONVERSATION
- END CONVERSATION
- GET CONVERSATION GROUP
- GET_TRANSMISSION_STATUS
- MOVE CONVERSATION
- RECEIVE
- SEND
- SET
- DATEFIRST
- NOEXEC
- LIMIT
- OFFSETS