運算子 (Transact-SQL)Operators (Transact-SQL)

適用於: 是SQL Server (從 2008 開始) 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server (starting with 2008) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

運算子是一個符號,負責指定針對一個或多個運算式所執行的動作。An operator is a symbol specifying an action that is performed on one or more expressions. 下表將列出 SQL ServerSQL Server 所用的運算子類別目錄。The following tables lists the operator categories that SQL ServerSQL Server uses.

算術運算子Arithmetic Operators 邏輯運算子Logical Operators
指派運算子Assignment Operator 範圍解析運算子Scope Resolution Operator
位元運算子Bitwise Operators 集合運算子Set Operators
比較運算子Comparison Operators 字串串連運算子String Concatenation Operator
複合運算子Compound Operators 一元運算子Unary Operators

另請參閱See Also

運算子優先順序 (Transact-SQL)Operator Precedence (Transact-SQL)