Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
teamjai
Yak Posting Veteran
52 Posts |
 Posted - 2012-01-02 : 04:45:29
|
Hello,The search functionality the user shall be able to find specific data by the fields “<column-name>”, if two search fields are filled, the search functionality should only display match both criteriaso how can i get data along with column name  |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-02 : 08:18:25
|
| There are a few different ways of doing this, each with its own advantages and disadvantages. The most obvious way (at least to me) turns out to be the worst from a performance perspective. Take a look at Sommarskag's blog here: http://www.sommarskog.se/dyn-search.html He discusses it in great detail with examples and performance considerations. |
 |
|
|
|
|
|
How to search function