Synametrics Technologies

Hi there,

Developpers will often give me batch INSERT or UPDATE statements in a SQL file, how can I import/run those in WinSQL?  And would it be the same process to run CREATE and ALTER scripts from a SQL file?

Thank you,
Chantal

Chantal,

There are two ways to do this:

1. Connect to your database, drag a .SQL file from Windows File Manager in the SQL Window in WinSQL and then run it.
2. Use the Scripting Wizard. Click Scripting Wizard under Tools menu. Add the SQL files and then execute.

Important: WinSQL uses the word 'GO' as a query terminator. If the script you are getting use a different terminator, such as a semi-colon, you will have to modify the query terminator in WinSQL. Check http://web.synametrics.com/queryterminator.htm for details.