Elementos del lenguaje T-SQL para un grupo de SQL dedicado en Azure Synapse AnalyticsT-SQL language elements for dedicated SQL pool in Azure Synapse Analytics
Vínculos a la documentación de los elementos de lenguaje T-SQL admitidos en un grupo de SQL dedicado.Links to the documentation for T-SQL language elements supported in dedicated SQL pool.
Elementos principalesCore elements
- convenciones de sintaxissyntax conventions
- reglas de nomenclatura de objetosobject naming rules
- palabras clave reservadasreserved keywords
- intercalacionescollations
- comentarioscomments
- constantesconstants
- tipos de datosdata types
- EXECUTEEXECUTE
- expresionesexpressions
- KILLKILL
- IDENTITY (propiedad), solución alternativaIDENTITY property workaround
- PRINTPRINT
- USEUSE
Lotes, control de flujo y variablesBatches, control-of-flow, and variables
- BEGIN...ENDBEGIN...END
- BREAKBREAK
- DECLARE @local_variableDECLARE @local_variable
- IF...ELSEIF...ELSE
- RAISERRORRAISERROR
- SET@local_variable
- THROWTHROW
- TRY...CATCHTRY...CATCH
- WHILEWHILE
OperadoresOperators
- + (Sumar)+ (Add)
- + (Concatenación de cadenas)+ (String Concatenation)
- - (Negativo)- (Negative)
- - (Restar)- (Subtract)
- * (Multiplicar)* (Multiply)
- / (Dividir)/ (Divide)
- MóduloModulo
Caracteres comodín que deben coincidirWildcard character(s) to match
- = (Es igual a)= (Equals)
- > (Mayor que)> (Greater than)
- < (Menor que)< (Less than)
- >= (Mayor o igual que)>= (Great than or equal to)
- <= (Menor o igual que)<= (Less than or equal to)
- < > (No igual a)<> (Not equal to)
- != (No igual a)!= (Not equal to)
- ANDAND
- BETWEENBETWEEN
- EXISTSEXISTS
- ININ
- IS [NOT] NULLIS [NOT] NULL
- LIKELIKE
- NOTNOT
- OROR
Operadores bit a bitBitwise operators
- & (AND bit a bit)& (Bitwise AND)
- | (OR bit a bit)| (Bitwise OR)
- ^ (OR exclusiva bit a bit)^ (Bitwise exclusive OR)
- ~ (NOT bit a bit)~ (Bitwise NOT)
- ^= (OR EQUALS exclusiva bit a bit)^= (Bitwise Exclusive OR EQUALS)
- |= (OR EQUALS bit a bit)|= (Bitwise OR EQUALS)
- &= (AND EQUALS bit a bit)&= (Bitwise AND EQUALS)
FunctionsFunctions
- @@DATEFIRST@@DATEFIRST
- @@ERROR@@ERROR
- @@LANGUAGE@@LANGUAGE
- @@SPID@@SPID
- @@TRANCOUNT@@TRANCOUNT
- @@VERSION@@VERSION
- ABSABS
- ACOSACOS
- ASCIIASCII
- ASINASIN
- ATANATAN
- ATN2ATN2
- BINARY_CHECKSUMBINARY_CHECKSUM
- CASECASE
- CAST y CONVERTCAST and CONVERT
- CEILINGCEILING
- CHARCHAR
- CHARINDEXCHARINDEX
- CHECKSUMCHECKSUM
- COALESCECOALESCE
- COL_NAMECOL_NAME
- COLLATIONPROPERTYCOLLATIONPROPERTY
- CONCATCONCAT
- COSCOS
- COTCOT
- COUNTCOUNT
- CONCAT_WSCONCAT_WS
- COUNT_BIGCOUNT_BIG
- CUME_DISTCUME_DIST
- CURRENT_TIMESTAMPCURRENT_TIMESTAMP
- CURRENT_USERCURRENT_USER
- DATABASEPROPERTYEXDATABASEPROPERTYEX
- DATALENGTHDATALENGTH
- DATEADDDATEADD
- DATEDIFFDATEDIFF
- DATEFROMPARTSDATEFROMPARTS
- DATENAMEDATENAME
- DATEPARTDATEPART
- DATETIME2FROMPARTSDATETIME2FROMPARTS
- DATETIMEFROMPARTSDATETIMEFROMPARTS
- DATETIMEOFFSETFROMPARTSDATETIMEOFFSETFROMPARTS
- DAYDAY
- DB_IDDB_ID
- DB_NAMEDB_NAME
- DEGREESDEGREES
- DENSE_RANKDENSE_RANK
- DIFFERENCEDIFFERENCE
- EOMONTHEOMONTH
- ERROR_MESSAGEERROR_MESSAGE
- ERROR_NUMBERERROR_NUMBER
- ERROR_PROCEDUREERROR_PROCEDURE
- ERROR_SEVERITYERROR_SEVERITY
- ERROR_STATEERROR_STATE
- EXPEXP
- FIRST_VALUEFIRST_VALUE
- FLOORFLOOR
- GETDATEGETDATE
- GETUTCDATEGETUTCDATE
- HAS_DBACCESSHAS_DBACCESS
- HASHBYTESHASHBYTES
- INDEXPROPERTYINDEXPROPERTY
- ISDATEISDATE
- ISNULLISNULL
- ISNUMERICISNUMERIC
- LAGLAG
- LAST_VALUELAST_VALUE
- LEADLEAD
- LEFTLEFT
- LENLEN
- LOGLOG
- LOG10LOG10
- LOWERLOWER
- LTRIMLTRIM
- MAXMAX
- MINMIN
- MONTHMONTH
- NCHARNCHAR
- NTILENTILE
- NULLIFNULLIF
- OBJECT_IDOBJECT_ID
- OBJECT_NAMEOBJECT_NAME
- OBJECTPROPERTYOBJECTPROPERTY
- OIBJECTPROPERTYEXOIBJECTPROPERTYEX
- ODBCS (funciones escalares)ODBCS scalar functions
- OVER (cláusula)OVER clause
- PARSENAMEPARSENAME
- PATINDEXPATINDEX
- PERCENTILE_CONTPERCENTILE_CONT
- PERCENTILE_DISCPERCENTILE_DISC
- PERCENT_RANKPERCENT_RANK
- PIPI
- POWERPOWER
- QUOTENAMEQUOTENAME
- RADIANSRADIANS
- RANDRAND
- RANKRANK
- REPLACEREPLACE
- REPLICATEREPLICATE
- REVERSEREVERSE
- RIGHTRIGHT
- ROUNDROUND
- ROW_NUMBERROW_NUMBER
- RTRIMRTRIM
- SCHEMA_IDSCHEMA_ID
- SCHEMA_NAMESCHEMA_NAME
- SERVERPROPERTYSERVERPROPERTY
- SESSION_USERSESSION_USER
- SIGNSIGN
- SINSIN
- SMALLDATETIMEFROMPARTSSMALLDATETIMEFROMPARTS
- SOUNDEXSOUNDEX
- SPACESPACE
- SQL_VARIANT_PROPERTYSQL_VARIANT_PROPERTY
- SQRTSQRT
- SQUARESQUARE
- STATS_DATESTATS_DATE
- STDEVSTDEV
- STDEVPSTDEVP
- STRSTR
- STRING_AGGSTRING_AGG
- STRING_SPLITSTRING_SPLIT
- STUFFSTUFF
- SUBSTRINGSUBSTRING
- SUMSUM
- SUSER_SNAMESUSER_SNAME
- SWITCHOFFSETSWITCHOFFSET
- SYSDATETIMESYSDATETIME
- SYSDATETIMEOFFSETSYSDATETIMEOFFSET
- SYSTEM_USERSYSTEM_USER
- SYSUTCDATETIMESYSUTCDATETIME
- TANTAN
- TERTIARY_WEIGHTSTERTIARY_WEIGHTS
- TIMEFROMPARTSTIMEFROMPARTS
- TRIMTRIM
- TODATETIMEOFFSETTODATETIMEOFFSET
- TYPE_IDTYPE_ID
- TYPE_NAMETYPE_NAME
- TYPEPROPERTYTYPEPROPERTY
- UNICODEUNICODE
- UPPERUPPER
- USERUSER
- USER_NAMEUSER_NAME
- VARVAR
- VARPVARP
- YEARYEAR
- XACT_STATEXACT_STATE
TransaccionesTransactions
Sesiones de diagnósticoDiagnostic sessions
ProcedimientosProcedures
- sp_addrolemembersp_addrolemember
- sp_columnssp_columns
- sp_configuresp_configure
- sp_datatype_info_90sp_datatype_info_90
- sp_droprolemembersp_droprolemember
- sp_executesp_execute
- sp_executesqlsp_executesql
- sp_fkeyssp_fkeys
- sp_pdw_add_network_credentialssp_pdw_add_network_credentials
- sp_pdw_database_encryptionsp_pdw_database_encryption
- sp_pdw_database_encryption_regenerate_system_keyssp_pdw_database_encryption_regenerate_system_keys
- sp_pdw_log_user_data_maskingsp_pdw_log_user_data_masking
- sp_pdw_remove_network_credentialssp_pdw_remove_network_credentials
- sp_pkeyssp_pkeys
- sp_preparesp_prepare
- sp_rename (preview)sp_rename (preview)
- sp_spaceusedsp_spaceused
- sp_special_columns_100sp_special_columns_100
- sp_sproc_columnssp_sproc_columns
- sp_statisticssp_statistics
- sp_tablessp_tables
- sp_unpreparesp_unprepare
SET, instruccionesSET statements
- SET ANSI_DEFAULTSSET ANSI_DEFAULTS
- SET ANSI_NULL_DFLT_OFFSET ANSI_NULL_DFLT_OFF
- SET ANSI_NULL_DFLT_ONSET ANSI_NULL_DFLT_ON
- SET ANSI_NULLSSET ANSI_NULLS
- SET ANSI_PADDINGSET ANSI_PADDING
- SET ANSI_WARNINGSSET ANSI_WARNINGS
- SET ARITHABORTSET ARITHABORT
- SET ARITHIGNORESET ARITHIGNORE
- SET CONCAT_NULL_YIELDS_NULLSET CONCAT_NULL_YIELDS_NULL
- SET DATEFIRSTSET DATEFIRST
- SET DATEFORMATSET DATEFORMAT
- SET FMTONLYSET FMTONLY
- SET IMPLICIT_TRANSACITONSSET IMPLICIT_TRANSACITONS
- SET LOCK_TIMEOUTSET LOCK_TIMEOUT
- SET NUMBERIC_ROUNDABORTSET NUMBERIC_ROUNDABORT
- SET QUOTED_IDENTIFIERSET QUOTED_IDENTIFIER
- SET ROWCOUNTSET ROWCOUNT
- SET TEXTSIZESET TEXTSIZE
- SET TRANSACTION ISOLATION LEVELSET TRANSACTION ISOLATION LEVEL
- SET XACT_ABORTSET XACT_ABORT
Pasos siguientesNext steps
Para obtener más información de referencia, consulte Instrucciones T-SQL en un grupo de SQL dedicado y Vistas del sistema en un grupo de SQL dedicado.For more reference information, see T-SQL statements in dedicated SQL pool, and System views in dedicated SQL pool.