Those were excellent answers, Dmorley and wildfrog.

Now to extend my question, does writing a stored procedure at the backend and then executing it at the backend too prove advantageous over writing a SQL query at the back end and firing it at the backend?

Your statement to the effect that SP's are precompiled makes me think. Do SQL queries not have execution plans too? One advantage might be the absence of line by line interpretation at run-time, but that happens to SQL queries only the first time until before they are cached, right? What's the mystery?