Synapse SQL 池支持的 T-SQL 语言元素T-SQL language elements supported in Synapse SQL pool
Synapse SQL 池支持的 T-SQL 语言元素的相关文档的链接。Links to the documentation for T-SQL language elements supported in Synapse 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
- 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
- STUFFSTUFF
- SUBSTRINGSUBSTRING
- SUMSUM
- SUSER_SNAMESUSER_SNAME
- SWITCHOFFSETSWITCHOFFSET
- SYSDATETIMESYSDATETIME
- SYSDATETIMEOFFSETSYSDATETIMEOFFSET
- SYSTEM_USERSYSTEM_USER
- SYSUTCDATETIMESYSUTCDATETIME
- TANTAN
- TERTIARY_WEIGHTSTERTIARY_WEIGHTS
- TIMEFROMPARTSTIMEFROMPARTS
- 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_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
有关更多参考信息，请参阅 Synapse SQL 池中的 T-SQL 语句和 Synapse SQL 池中的系统视图。For more reference information, see T-SQL statements in Synapse SQL pool, and System views in Synapse SQL pool.