Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create SQL Server database from VFP Code
Message
From
09/11/2006 10:23:04
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01168252
Message ID:
01168444
Views:
17
Thanks for the explanation!

>Some T-SQL command can only be executed in separate batches. SQL Server will generate an error if the're combined with other statements. The "GO" statement is an instruction to the tools that process a script to treat whatever comes before it as separate batch and send to SQL Server. SSMS itself does respect the "GO" statement.
>
>>if it's not part of the language why does SSMS put it in when generating the script?
>>
>>>The "GO" statement isn't a part of T-SQL language. You'll have to parse script and send each batch separatelly.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Reply
Map
View

Click here to load this message in the networking platform