28 reputation
2
bio website
location
age
visits member for 1 year, 10 months
seen Oct 15 '13 at 7:29

Dec
7
comment Multi part identifier in Microsoft SQL Server
@Martin: you were right. It's a SQL 6.5 bug, solved in SQL Server 7.0. I can make that query work on SQL 2000 with compatibility level up to 65.
Dec
7
awarded  Scholar
Dec
7
accepted Multi part identifier in Microsoft SQL Server
Dec
7
comment Multi part identifier in Microsoft SQL Server
Yes Richard, I know that, I was just hoping :)
Dec
6
awarded  Student
Dec
6
comment Multi part identifier in Microsoft SQL Server
Thanks Martin. I'v tried the same query in SQL 2008 with SQL 2000 compatibility level and it doesn't work. Maybe the bug was resolved in SQL 2000. I'm gonna investigate for one more day and then I'll mark your answer as accepted.
Dec
6
comment Multi part identifier in Microsoft SQL Server
The complete query is as follow: 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 6.5
Dec
6
asked Multi part identifier in Microsoft SQL Server