sql set variable with stored procedure result code example

Example: declare variable in stored procedure in sql server

DECLARE 
    @product_name VARCHAR(MAX),
    @list_price DECIMAL(10,2);