Syntax
The DECLARE statement has the following format:
DECLARE var_name {, var_name} [=] var_type
[NOT NULL [WITH | NOT DEFAULT] | WITH NULL];
{var_name {, var_name} [=] var_type
[NOT NULL [WITH | NOT DEFAULT] | WITH NULL];}
var_name
Specifies the name of the local variable. A variable name must be unique within the procedure; it cannot match the name of any other procedure variable or parameter.
var_type
Is the data type of the variable. A local variable can be any data type except a SYSTEM_MAINTAINED TABLE_KEY or OBJECT_KEY.