具有多个可选搜索参数的sql搜索查询

I have to write a search query in sql 2008 which can use multiple optionalI have to write a search query in sql 2008 whic