Local variables are declared, named, and typed with the declare keyword and are assigned an initial value with a select statement; this must all happen within the same batch or procedure.