I&#039;ve just recently started using stored procedures to do database queries. I was wondering though, what is the best way to implement stored procedures?<BR><BR>Should I create 4 stored procedures for each table (INSERT, UPDATE, DELETE, and SELECT)? If I do this, I would have to include all the parameters of the stored proc when using it on a page. However, many times I may not be using all the fields of a particular table in my page. This suggests writing a different stored procedure for every page. This would help me do queries on more than one table. But I guess I should be using views to do that. Perhaps stored procedures on views?<BR><BR>I realize it may depend mostly on what your needs are. I was just wondering if those ASP experts out there have some "best practices" for stored procs.