Getting value in swlwct query inside SP & store it in variable in Sql

This is a small example,where we can execute the select query & store   the value in a variable in sql query.

Declare @cnt  int
Select  @cnt= COUNT(*) FROM orderhead
print @cnt