SQL Server *= Operator?

by

Remove this code immediately and replace with a left join. This code does not always interpret correctly (Sometimes SQL Server decides it is a cross join) even in SQL Server 2000 and thus can give incorrect results! Also it is deprecated for the future (Using Outer Joins, SQL Server 2000 documentation archived from the original).

I’m going to add that in adjusting to left joins you should remove all of those other implicit joins as well. The implicit join syntax has been obsolete since 1992, there is no excuse for it still being in production code. And mixing implicit and explicit joins can give unexpected results.

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. Max sal to print base on manager_id
  3. Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’
  4. Should I use != or for not equal in T-SQL?
  5. sql server 2008 management studio not checking the syntax of my query
  6. Conversion failed when converting date and/or time from character string while inserting datetime
  7. Create a date from day month and year with T-SQL
  8. How should I pass a table name into a stored proc?
  9. Difference between left join and right join in SQL Server [duplicate]
  10. Get the last inserted row ID (with SQL statement) [duplicate]
  11. Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
  12. Get the week start date and week end date from week number
  13. conditional unique constraint
  14. Run all SQL files in a directory
  15. SELECT FOR UPDATE with SQL Server
  16. How to group by month from Date field using sql
  17. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  18. Why is my t-sql left join not working?
  19. How to get the numeric part from a string using T-SQL?
  20. SQL Server Update Trigger, Get Only modified fields
  21. Grouped string aggregation / LISTAGG for SQL Server
  22. Curly braces in T-SQL
  23. How to find column names for all tables in all databases in SQL Server
  24. How do I add a auto_increment primary key in SQL Server database?
  25. SQL Row_Number() function in Where Clause
  26. SQL update trigger only when column is modified
  27. Add a column to existing table and uniquely number them on MS SQL Server
  28. How to execute a stored procedure inside a select query
  29. How to Execute SQL Query without Displaying results
  30. SQL Inner Join On Null Values

Leave a Comment