Posted by Erland Sommarskog on 02/14/07 22:49

BJMurphy (murphy.ben@gmail.com) writes:
> For example:
>
> create table foo;
> select * from bar into foo;
> select * from foo where (true);
>
> Is then equivalent to:
> create table foo
> go
> select * from bar into foo
> go
> select * from foo where (true);
>
> Again, assuming the queries run succesfully.

Well, since two of them has syntax errors, they will not. So
the first batch will fail. But if you run the second set of bathces,
the second statement will create the table "foo".

> Is there a way to create global variables?

No. The place to write data that needs to be persisted over batches
is in tables, typically temp tables.

(OK, there is a command SET CONTEXT_INFO which could be used for
this, but it's not anywhere close to practical for this purpose.)



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]