Will a single stored procedure generated dynamically for website work fine?

Question

Hi all,

Please suggest me on this.. If not should i create sp dor all the tables for a web application/website