General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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