Select to an output parameter at a stored procedure.

SELECT TOP 1 @ValueToReturn = HorseName FROM Horses

...is how it is done in lieu of...

SELECT TOP 1 HorseName FROM Horses

 
 

This is an older blog posting I wrote on output parameters for stored procedures.