Variables and null values  Transactions and global variables

Chapter 14: Using Batches and Control-of-Flow Language

Global variables

Global variables are system-supplied, predefined variables. They are distinguished from local variables by the two @ signs preceding their names—for example, @@error. The two @ signs are considered part of the identifier used to define the global variable.

Users cannot create global variables and cannot update the value of global variables directly in a select statement. If a user declares a local variable that has the same name as a global variable, that variable is treated as a local variable.





Copyright © 2005. Sybase Inc. All rights reserved. Transactions and global variables

View this book as PDF