WinSQL » Knowledge base

Document information

Document ID: 826
Subject: What is a query terminator
Creation date: 7/29/09 5:01 PM
Last modified on: 12/12/18 11:07 AM


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.







Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users?

Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our public forums to post questions.

Navigation

Social Media

Powered by 10MinutesWeb.com