Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Scripts
Message
From
05/10/2002 08:42:35
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00706584
Message ID:
00708059
Views:
34
There is a file in the Binn directory of the MS Sql called isql.exe. With this executable you can run SQL Srcipts (MS-DOS Text(OEM) or Windows-Text(ANSI)).
You can check the sintax of the command by executing 'isql -?', but I use like this:
isql -S Name_of_Server -d Database_name -U User_name -P Password -i Name_of_Script_File

You can run this from the command line (Dos or Windows) or inside of you Application using Run or ShellExecute() or WinExec().

P.S.: The switches of the command are case-sensitive.

Any time...

Silvio
Previous
Reply
Map
View

Click here to load this message in the networking platform