Synametrics Technologies

Document Details

Most databases accept only one SQL query per statement. This means, you can submit a SQL query, wait for its response and then submit another one. In such cases, you can use a Query Terminator in WinSQL to break your scripts into multiple queries before submitting it to the back-end database. Query Terminator allow users to write a script like:

select * from customer
go
select * from orders

In this case WinSQL will first send a query to fetch records from customer and then send a second request for the orders table.

By default WinSQL uses the word "GO" as a Query Terminator. To change this value click Edit/Options on the main menu and change the value for Query Terminator String

Note that some databases like MS SQL Server and Sybase, allow multiple queries per statement. For such database you are not required to use a terminator.