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:10/15/14 9:12 AM


Document Details

Most databases expect only one SQL query per statement - meaning 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? Please add it below. Your name and tip will appear at the end of the document text.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters

Navigation

Social Media

Powered by 10MinutesWeb.com