!>(不大於) (Transact-SQL)!> (Not Greater Than) (Transact-SQL)

適用於: 是SQL Server 是Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

比較兩個運算式 (比較運算子)。Compares two expressions (a comparison operator). 當您在比較非 Null 運算式時,如果左運算元的值不大於右運算元,則結果為 TRUE。When you compare non-null expressions, the result is TRUE if the left operand doesn't have a greater value than the right operand. 否則,結果為 FALSE。Otherwise, the result is FALSE. 與 = (等於) 比較運算子不同的是,兩個 NULL 值的 !> 比較結果,不受 ANSI_NULLS 設定的影響。Unlike the = (equality) comparison operator, the result of the !> comparison of two NULL values doesn't depend on the ANSI_NULLS setting.

文章連結圖示 Transact-SQL 語法慣例Article link icon Transact-SQL Syntax Conventions

語法Syntax

  
expression !> expression  

引數Arguments

expressionexpression
這是任何有效的運算式Is any valid expression. 這兩個運算式的類型,都必須是可以隱含轉換的資料類型。Both expressions must have implicitly convertible data types. 轉換會隨著資料類型優先順序的規則而不同。The conversion depends on the rules of data type precedence.

結果類型Result Types

布林Boolean

另請參閱See Also

資料類型 (Transact-SQL) Data Types (Transact-SQL)
運算子 (Transact-SQL)Operators (Transact-SQL)