Multiple choice technology databases

*= operator belongs to SQL server 2008

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The non-standard *= outer join operator was deprecated in SQL Server 2005 and is not supported in SQL Server 2008 compatibility modes under level 100, which requires the standard ANSI LEFT OUTER JOIN.

Keep practicing — related questions