Chapter 15: Using Batches and Control-of-Flow Language
Local variables and update statements
You can
assign variables directly in an update statement.
You do not need to use a select statement to
assign a value to a variable. When you declare a variable, it has
the value NULL.