I have an application developed in .NET and the queries through stored procedures in SQL Server 2008, .NET Framework 4.0.

In stored procedures I have two sets :

1. each stored procedure contains only one query from a table
2. a stored procedure has entire queries related to that table

Example : 

```
IF @Type = 'Select'
   'query'

IF @Type = 'Search'
   ''query

```

As I have developed the application and using both sets, I'm confused as to whether writing entire queries for a table (set 2) is a good practise?

Do that have any advantage or is it a bad coding practise to follow (ie. writing multiple queries in individual stored procedures)

Please suggest me options to follow.

Thank you