network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 5 months |
| seen | Feb 14 at 13:53 | |
| stats | profile views | 1 |
|
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 |
