Search SSWUG.ORG:

DATABASES

Compare and sync tables: Generating the code This is an off-site link.  Please review our Terms of Service for additional information.




(stewashton) To conclude my presentation of the GROUP BY + MERGE technique, here is a query that generates the SQL to synchronize two tables. You just need to specify the source and the target; the source can be a local or remote table or view, or a query. The target must be a local table with a primary key.

Read this article...







comments powered by Disqus