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

适用对象:是SQL Server 是Azure SQL 数据库 否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

BooleanBoolean

另请参阅See Also

数据类型 (Transact-SQL) Data Types (Transact-SQL)
运算符 (Transact-SQL)Operators (Transact-SQL)