Posted by Erland Sommarskog on 01/06/07 13:59

fireball (fireball@onet.kropka.eu) writes:
> Uzytkownik "Hugo Kornelis" <hugo@perFact.REMOVETHIS.info.INVALID> napisal
>> there are some statements
>> that have to run in a seperate batch.
>
> do I need to redeclare all variables (and re-set it's values) I still use
> after starting new batch in my script? :O

The scope of a variable is a batch. But you can run these commands that
require a separate batch from EXEC().


--
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]