SQL Server Performance

which is the best method to serch data based on user parameter?

Discussion in 'SQL Server 2005 General Developer Questions' started by AJITH123, Aug 18, 2008.

  1. AJITH123 Member

    Hi,
    Can any body tell, which is the best approach to search ceretain records by getting user parameter? say, suppose i have a procedure having 50 input parameter, based on this parameter i need to execute a query, there is some chances that, parameter will not have values. The approch we can do is, create dynamic query and pass the paramater in the where clause, or create query by passing '%' value. Rather thann this, any body suggest best methos to search certain items?
    Thanks
    Ajith
  2. FrankKalis Moderator

    One of the most read article regarding this can be found at http://www.sommarskog.se/dyn-search.html. Lots of ideas there.

Share This Page