sql - 我应该在T-SQL中使用！=或<>表示不相等吗？(Should I use != or <> for not equal in T-SQL?)

Question

I have seen SQL that uses both != and <> for not equal .

(我见过使用!=和<>表示不相等的 SQL 。)

What is the preferred syntax and why?

(首选语法是什么，为什么？)

I like != , because <> reminds me of Visual Basic .

(我喜欢!= ，因为<>我想起了Visual Basic 。)

  ask by Bob The Janitor translate from so

Answer 1

Most databases support != (popular programming languages) and <> (ANSI).

(大多数数据库都支持!= （流行的编程语言）和<> （ANSI）。)

Databases that support both != and <> :

(同时支持!=和<> ：)

• MySQL 5.1: != and <>

  (MySQL 5.1： !=和<>)

• PostgreSQL 8.3: != and <>

  (PostgreSQL 8.3： !=和<>)

• SQLite: != and <>

  (SQLite： !=和<>)

• Oracle 10g: != and <>

  (Oracle 10g： !=和<>)

• Microsoft SQL Server 2000/2005/2008/2012/2016: != and <>

  (Microsoft SQL Server 2000/2005/2008/2012/2016： !=和<>)

• IBM Informix Dynamic Server 10: != and <>

  (IBM Informix Dynamic Server 10： !=和<>)

• InterBase/Firebird: != and <>

  (InterBase / Firebird： !=和<>)

• Apache Derby 10.6: != and <>

  (Apache Derby 10.6： !=和<>)

• Sybase Adaptive Server Enterprise 11.0: != and <>

  (Sybase Adaptive Server Enterprise 11.0： !=和<>)

Databases that support the ANSI standard operator, exclusively :

(支持ANSI标准的运营商， 专门数据库：)

• IBM DB2 UDB 9.5: <>

  (IBM DB2 UDB 9.5： <>)

• Microsoft Access 2010: <>

  (Microsoft Access 2010： <>)