Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GROUP BY 1 no longer works
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00750415
Message ID:
00754282
Vues:
16
>>>No, I don't think ANSI has a "SET ENGINEBEHAVIOR". It is the VFP8 IMPLEMENTATION that I would rather have seen done differently.
>>
>>Actually, it does. SQL Server has a compatibility stored procedure to set the compatibility level. This was begun in SQL Server 7.0. 6.5 handled things like including fields in the select stateament that weren't in the group by clause when dealing with aggregate functions.
>
>Sure for SQL Server. But not ANSI, surely.

SQL Server didn't, like Fox, exhibit as high degree of compliance with ANSI-92 as, perhaps, it should have. What both the SQL Server team and the Fox team did was give a method that allowed existing SQL to function as it had before.
George

Ubi caritas et amor, deus ibi est
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform