I'm migrating a SQL Server 6.5 database to SQL Server 2012. Migration went well but one of the software using this database performs a strange query:
UPDATE myTable SET Field1='',Field2=0, a.Field3=14 WHERE Field10=1
The problem lies of course with the identifier ('a') before Field3. There are no views, aliases or join with that name but for SQL Server 6,5 that is a valid query.
Since I'm not familiar with SQL Server 6.5, do any of you remember the meaning of this syntax?
The software using this query is an old one of which I don't have any sources (and the company that made it is now closed...), so changing the query is not an option.
The full query is
UPDATE SituazioneMacchina SET DatiSetPointSpediti='' , SpedMappa=0 , NrRichMappa=0 , DatiSetPoint='' , a.IDProduzione=14 WHERE NumMacchina=1
If I change "a.IDProduzione" with something like "fasdffas.IDProduzione", the query still works in SQL Server 6.5