Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL2008 Merge
Message
De
25/08/2008 07:25:09
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL2008 Merge
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
MS SQL Server
Divers
Thread ID:
01341455
Message ID:
01341455
Vues:
65
Has anyone tried to use the new MERGE T-SQL Command of SQL Server 2008? I think it could be worth trying to make the Cursoradapter use MERGE commands triggered by Tableupdate(.T.) instead of single record INSERT/UPDATE/DELETE commands, although it would mean to implement the overhead of first sending (parts) of the Cursoradapter Cursor to SQL as #TEMP table and afterwards make the MERGE from there.

Do you have a better idea or already tried something?
Or do you see some ill logic when it comes to conflicting updates?
Is it really woth the hassle?

Bye, Olaf.
Répondre
Fil
Voir

Click here to load this message in the networking platform