How to search a column value of a particular table in SQL Server?

Question

Input :

EMP table has 100 columns. If we type any value for @searchparameter, it's like Google search. It has to check all the columns internally and display the relevant rows of all columns

EmpID    Ename    Designation   
-----------------------------    
1        swami      GM
2        kiran      test

Output :

@Search = 'GM'

EmpID    Ename    Designation   
-----------------------------    
1        swami      GM

Possible duplicate of [SQL Server SELECT where any column contains 'x'](http://stackoverflow.com/questions/28717868/sql-server-select-where-any-column-contains-x) — CollinD, Jan 25 '17 at 00:39

score 0 · Answer 1 · edited May 23 '17 at 11:52

0

Look at:

And build your procedure using

DYNAMIC QUERIES (sp_executesql)

You can find some examples in SO:

How do I find a value anywhere in a SQL Server Database?

edited May 23 '17 at 11:52

Community

1
1

answered Jan 25 '17 at 00:41

McNets

10,352
3
32
61

I am not able to change the code as per my requirement . could you please help on this. – SNR Jan 25 '17 at 00:52
Have you a query that do searches in your table or you need a query? – McNets Jan 25 '17 at 00:55

How to search a column value of a particular table in SQL Server?

1 Answers1