Is there any difference between IS NULL and =NULL

by

= NULL is always unknown (this is piece of 3 state logic), but WHERE clause treats it as false and drops from the result set. So for NULL you should use IS NULL

Reasons are described here: Why does NULL = NULL evaluate to false in SQL server

More Related Contents:

  1. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  2. How can I do an UPDATE statement with JOIN in SQL Server?
  3. The multi-part identifier could not be bound
  4. How to return multiple values in one column (T-SQL)?
  5. SQL – Subtracting a depleting value from rows
  6. Turn off constraints temporarily (MS SQL)
  7. Pass table as parameter into sql server UDF
  8. conditional unique constraint
  9. Can a Check constraint relate to another table?
  10. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  11. How to Replace Multiple Characters in SQL?
  12. SELECT FOR UPDATE with SQL Server
  13. EXISTS vs JOIN and use of EXISTS clause
  14. SQL comma-separated row with Group By clause
  15. How to copy a huge table data into another table in SQL Server
  16. How to split string using delimiter char using T-SQL?
  17. Should I use SQL_Variant data type?
  18. Performance of SQL Server 2005 Query
  19. OPENXML with xmlns:dt
  20. SQL server select distinct rows using most recent value only
  21. Script to save varbinary data to disk
  22. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  23. How to select date without time in SQL
  24. What is the internal representation of datetime in sql server?
  25. Eliminate and reduce overlapping date ranges
  26. Cumulative Total in MS Sql server [duplicate]
  27. SQL query to group by day
  28. Export table data from one SQL Server to another
  29. SQL can I have a “conditionally unique” constraint on a table?
  30. SQL, How to Concatenate results?

Leave a Comment