Hi Friends - I would like to know which is more efficient and faster between Stored Proceure and writting SQL Statement in your code.

What I am trying to find out is, will it be better to use a stored procedire to get your records or get your records by writting SQL statement in your code.

Which one of the 2 should be used?

Plese help....

Thanks