Should I use != or for not equal in T-SQL?

by

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

Databases that support both != and <>:

Databases that support the ANSI standard operator, exclusively:

  • IBM DB2 UDB 9.5: <>
  • Microsoft Access 2010: <>

More Related Contents:

  1. How do I perform an IF…THEN in an SQL SELECT?
  2. Inserting multiple rows in a single SQL query? [duplicate]
  3. Passing a varchar full of comma delimited values to a SQL Server IN function
  4. SQL update query using joins
  5. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  6. Is there a combination of “LIKE” and “IN” in SQL?
  7. Convert Month Number to Month Name Function in SQL
  8. Multiple INSERT statements vs. single INSERT with multiple VALUES
  9. Limit on the WHERE col IN (…) condition
  10. Removing leading zeroes from a field in a SQL statement
  11. Generate a resultset of incrementing dates in TSQL
  12. Getting result of dynamic SQL into a variable for sql-server
  13. How to get difference between two rows for a column field?
  14. Better techniques for trimming leading zeros in SQL Server?
  15. How do I split a delimited string so I can access individual items?
  16. Common Table Expression, why semicolon?
  17. T-SQL split string based on delimiter
  18. SQL Server SELECT into existing table
  19. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  20. Why use Select Top 100 Percent?
  21. How do I prevent a database trigger from recursing?
  22. What is the Null Character literal in TSQL?
  23. Aggregate function in an SQL update query?
  24. SQL Server : SUM() of multiple rows including where clauses
  25. How to combine results of two queries into a single dataset
  26. SQL Server 2005 and temporary table scope
  27. Executing SQL Server Agent Job from a stored procedure and returning job result
  28. SUM total time in SQL Server [duplicate]
  29. Memory effective way to read BLOB data in C#/SQL 2005
  30. How to insert Arabic characters into SQL database?

Leave a Comment