Azure Synapse Analytics 中专用 SQL 池的 T-SQL 语言元素T-SQL language elements for dedicated SQL pool in Azure Synapse Analytics
专用 SQL 池支持的 T-SQL 语言元素的相关文档的链接。Links to the documentation for T-SQL language elements supported in dedicated SQL pool.
核心元素Core elements
- 语法约定syntax conventions
- 对象命名规则object naming rules
- 保留的关键字reserved keywords
- 排序规则collations
- 注释comments
- 常量constants
- 数据类型data types
- EXECUTEEXECUTE
- 表达式expressions
- KILLKILL
- IDENTITY 属性解决方法IDENTITY property workaround
- PRINTPRINT
- USEUSE
批、流控制和变量Batches, 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
运算符Operators
- +(加)+ (Add)
- +(字符串串联)+ (String Concatenation)
- -(负)- (Negative)
- -(减)- (Subtract)
- *(乘)* (Multiply)
- /(除)/ (Divide)
- 取模Modulo
要匹配的通配符Wildcard character(s) to match
- =(等于)= (Equals)
- >(大于)> (Greater than)
- <(小于)< (Less than)
- >=(大于或等于)>= (Great than or equal to)
- <=(小于或等于)<= (Less than or equal to)
- <>(不等于)<> (Not equal to)
- !=(不等于)!= (Not equal to)
- ANDAND
- BETWEENBETWEEN
- EXISTSEXISTS
- ININ
- IS [NOT] NULLIS [NOT] NULL
- LIKELIKE
- NOTNOT
- OROR
位运算符Bitwise operators
- &(位与)& (Bitwise AND)
- |(位或)| (Bitwise OR)
- ^(位异或)^ (Bitwise exclusive OR)
- ~(位非)~ (Bitwise NOT)
- ^=(位异或等于)^= (Bitwise Exclusive OR EQUALS)
- |=(位或等于)|= (Bitwise OR EQUALS)
- &=(位与等于)&= (Bitwise AND EQUALS)
函数Functions
- @@DATEFIRST@@DATEFIRST
- @@ERROR@@ERROR
- @@LANGUAGE@@LANGUAGE
- @@SPID@@SPID
- @@TRANCOUNT@@TRANCOUNT
- @@VERSION@@VERSION
- ABSABS
- ACOSACOS
- ASCIIASCII
- ASINASIN
- ATANATAN
- ATN2ATN2
- BINARY_CHECKSUMBINARY_CHECKSUM
- CASECASE
- CAST 和 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 标量函数ODBCS scalar functions
- OVER 子句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
事务Transactions
诊断会话Diagnostic sessions
过程Procedures
- 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(预览版)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 语句SET 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
后续步骤Next steps
有关更多参考信息,请参阅专用 SQL 池中的 T-SQL 语句和专用 SQL 池中的系统视图。For more reference information, see T-SQL statements in dedicated SQL pool, and System views in dedicated SQL pool.