YOU HAVE AN APPLICATION THAT IS BEING UPGRADED FROM SQL SERVER 200..

5. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P9 PPTX
THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P9 PPTX
5. You have an application that is being upgraded from SQL Server 2005 to SQL Server 2008. You notice that some stored procedures are not working correctly. An excerpt is as follows:

SELECT *

FROM Territories, Region

WHERE territories.regionid *= region.regionid

What should you do to resolve the issue?A. There is no issue. The problem lies elsewhere.B. The join syntax is incorrect. Replace with left join.C. The select is incorrect. You need to enumerate the fields.D. The where clause should be = not *=.