I have database in SQL Server 2008 R2. I took a backup of this database and restored that on a SQL Server 2014 server. However, some of the database queries are not looking compatible to the new version.
*= operator is throwing errors in SQL Server 2014.
I don't want to change each query where I get issue. Is there any way to upgrade the older version of SQL Server backup to work with the newer version of database?