General information
Title:
C/S Newbie Q: Sending Batch of Statements
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only