Should I use or for not equal in T-SQL

Question

SQL uses both != and <> for not equal. What is syntax is the preferred one and why?

Answer 1

Most of the existing databases support !=

Databases that support both of these: != and <> are-

• MySQL 5.1
• SQLite
• Oracle 10g
• IBM Informix Dynamic Server 10
• Microsoft SQL Server 2000/2005/2008/2012/2016
• InterBase/Firebird
• PostgreSQL 8.3
• Apache Derby 10.6
• Sybase Adaptive Server Enterprise 11.0
• Mimer SQL 11.0

Databases that support <> , exclusively:

• IBM DB2 UDB 9.5
• Microsoft Access 2010