Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
C/S Newbie Q: Sending Batch of Statements
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
C/S Newbie Q: Sending Batch of Statements
Divers
Thread ID:
00365636
Message ID:
00365636
Vues:
60
Please excuse the C/S newbie Q but how do I send all of this below from VFP to SQL Server. Is there a way to make it all go through one SQLEXEC command? I'm familiar only with using SQLEXEC to send one commnand at a time.

IF EXISTS (SELECT * FROM sysobjects WHERE name='cust' and type='U')
DROP TABLE cust
go

CREATE TABLE dbo.Cust ( cust char (8) NOT NULL ,
baname char (10) NULL ,
custdesc char (35) NULL ,
subref char (3) NULL ,
respdept char (5) NULL )
go
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform