Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Running SQL Script
Message
 
 
À
17/12/2009 00:40:34
Hong Yew
People Quest
Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01439526
Message ID:
01439545
Vues:
69
There are a few ways you can do that (in no particular order)
  • SQLEXEC(lnConn, FILETOSTR(lcScripFileName)). Keep in mind that 'GO' statement isn't a part of T-SQL. If the batch includes 'GO' statements, you'll have to parse it and send each one separatelly.
  • SqlCmd command line utility
  • SQL DMO/SMO

    >
    >How can I execute a bunch of SQL statements in a SQL script file from within VFP using SQLEXEC or some other way?
    >
    --sb--
  • Précédent
    Répondre
    Fil
    Voir

    Click here to load this message in the networking platform