了解简单存储过程：将输出移动到变量

I'm hoping I can get some help with understanding a simple stored procedure. Basically, I want to store the output of a select statement in a variable and then print out the value of the variable.I'm hoping I can get some help with understandi