参见英文答案 >
Should I use != or <> for not equal in T-SQL?14个答案>
What is difference between operater != and <> in SQL Server? [duplicate]3个答案有什么区别！=和<> sql Server中的运算符？
因为两者都用作非运算符。例如：
select * from TableName where ColName <> value
要么
select * from TableName where ColName != value
返回相同的值(行)。
