Why should I use GO command in sybase?

Question

Why should I use GO when writing sql for sybase? In most of the existing sql my project has, there are no GOs but when DDL is generated for table creation, as an example, the application inserts many GO statements.

Thanks to the answers, I understand that GO is similar to ; in other databases, as people have helpfully pointed out it is a Delimiter.

An added question then, is GO in sybase exactly equivalent to typing ; in Oracle?

It's a non standard replacement for the standard statement delimiter `;` — , Nov 14 '11 at 19:09
@a_horse_with_no_name - It is a batch delimiter not a statement delimiter. — Martin Smith, Nov 14 '11 at 22:08
I don't understand why this has been voted down so much. I understand there are means of getting information on GO using google, however I was asking for user's experience. — prismaticorb, Feb 03 '12 at 13:48

score 13 · Accepted Answer · edited Feb 28 '12 at 13:53

13

It's a batch separator. GO is used to tell the engine to process everything after the word GO as a new command in a batch.

CREATE PROC usp_blah as ...
GO

CREATE some-otherproc as ...
GO

Without GO, the optimizer would throw an error at the second CREATE statement

edited Feb 28 '12 at 13:53

JeremyP

84,577
15
123
161

answered Nov 14 '11 at 18:21

Stuart Ainsworth

12,792
41
46

score 5 · Answer 2 · answered Nov 14 '11 at 22:04

Compare:

    Do something
    GO
    Do something else
    Go

To:

    Do something
    Do something else

If there is an error during 'Do something' in the first example then 'Do something else' will still run. This is not the case in the second example. And as Stuart pointed out there are some actions that require have to be the first statement of a batch, meaning you have to place GO before them unless the are the first line of your file.

score 3 · Answer 3 · edited Feb 14 '12 at 21:27

3

GO is a SQL Delimiter

Any occurrence of [gG][oO] in the text of a job command is seen as the batch delimiter go.

edited Feb 14 '12 at 21:27

prismaticorb

895
1
8
18

answered Nov 14 '11 at 21:58

aF.

64,980
43
135
198

score 2 · Answer 4 · answered Aug 17 '17 at 10:11

The so-called delimiter go isn't any of part of SAP/Sybase Transact-SQL language syntax.

It is commonly being thought of as a batch delimiter to separate a bunch of T-SQL statements from the next.

Since all SAP/Sybase batch scripts are executed using the native isql command line client, go is being interpreted by the isql client as a signal to submit all T-SQL commands entered in its buffer so far to the ASE server over the Server-Client user network connection (go does not appear in the network trace, it is not sent to the server).

Incidentally, isql would only recognise go in lower case only and not proceeded by any white spaces.

Why should I use GO command in sybase?

4 Answers4