Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1098

Re: When to Use GO

Show all headers | View raw

On Thu, 31 May 2012 07:29:17 +0000 (UTC), Erland Sommarskog
<esquel@sommarskog.se> wrote:

>Gene Wirchenko (genew@ocis.net) writes:
>>      I have a script where I very early delete the database and
>> recreate it.  In one recent problem area, I create a procedure.  It
>> has a GO in front of it, because stored procedures have to be first in
>> a batch.  Fine.  If I then follow with a CREATE TABLE in the same
>> batch, 
>
>You can't. That CREATE TABLE is part of the procedure. CREATE PROCEDURE must 
>be the first command in the batch, and it is the only command in the batch, 
>a property it shares with a couple of more commands.

     I have not read anything stating about a CREATE PROCEDURE having
to be the only command in a batch.  But, as my post shows, I have
discovered it myself.  Curse incomplete docs.

>Again, put your source code under version-control and load the files from
>a client-side program. Then you don't need to ask these questions.

     I am experimenting in SSMS.  I do not want the overhead.

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

When to Use GO Gene Wirchenko <genew@ocis.net> - 2012-05-30 14:21 -0700
  Re: When to Use GO Erland Sommarskog <esquel@sommarskog.se> - 2012-05-31 07:29 +0000
    Re: When to Use GO Gene Wirchenko <genew@ocis.net> - 2012-05-31 10:07 -0700
      Re: When to Use GO Erland Sommarskog <esquel@sommarskog.se> - 2012-05-31 22:26 +0200
        Re: When to Use GO Gene Wirchenko <genew@ocis.net> - 2012-06-01 09:41 -0700
          Re: When to Use GO Erland Sommarskog <esquel@sommarskog.se> - 2012-06-01 23:23 +0200
            Re: When to Use GO Gene Wirchenko <genew@ocis.net> - 2012-06-03 19:36 -0700
  Re: When to Use GO "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-05-31 06:45 -0400

csiph-web