Its necessary to run stored procedure everytime???

Question

 Hello all,

 Its necessary to write stored procedure for select queries that returns multiple records??

Whats performance difference if i run a select query using stored procedure

stead of running query through any server language???