What does =* mean?

by

This:

WHERE t.column =* s.column

…is old TSQL (pre SQL Server 2005) outer join syntax, and is not an ANSI JOIN.

Reference: SQL Server 2005 Outer Join Gotcha

More Related Contents:

  1. Generate a resultset of incrementing dates in TSQL
  2. T-SQL Cast versus Convert
  3. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  4. What is the difference between using a cross join and putting a comma between the two tables?
  5. Correct use of transactions in SQL Server
  6. Why do you create a View in a database?
  7. Need to list all triggers in SQL Server database with table name and table’s schema
  8. Know relationships between all the tables of database in SQL Server
  9. SQL Server search using like while ignoring blank spaces
  10. SQL where clause odd behavior [closed]
  11. How do I obtain a Query Execution Plan in SQL Server?
  12. How do I escape a single quote in SQL Server?
  13. Only inserting a row if it’s not already there
  14. Unpivot with column name
  15. Selecting data from two different servers in SQL Server
  16. Generate SQL Create Scripts for existing tables with Query
  17. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  18. How do I delete from multiple tables using INNER JOIN in SQL server
  19. SQL : BETWEEN vs =
  20. Splitting the string in sql server
  21. Count based on condition in SQL Server
  22. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  23. Best equivalent for IsInteger in SQL Server
  24. Syntax of for-loop in SQL Server
  25. Comma separated values in a database field
  26. Can SQL Server Express LocalDB be connected to remotely?
  27. How to correctly insert newline in nvarchar [duplicate]
  28. How do you copy a record in a SQL table but swap out the unique id of the new row?
  29. Using IF ELSE statement based on Count to execute different Insert statements
  30. Group consecutive rows of same value using time spans

Leave a Comment