I was looking for a generic Procedure in Sql Server
I need to search for
a given value in
a given list of Columns in
a given List of Tables in
a Given Schema
For example ( Just a fictitious example)
SearchValue = 'TestValue'
SearchColumns = 'ID, Name, Description'
SearchTables = 'TB_Category,TB_Address'
(The Table Names or Column names can be kept as List or whatever convenient )