Search in all tables for a given where condition
-
I would like to search all User defined tables in a database for given condition. Say for example my condition is (playerid = 10000052 or tripid = 10000124 ) and TripDtm = '2013-02-03 00:00:00.00 +00:00' I would like to get result from the tables which return at least one record for the condition. How to achieve this? Please do assist.
-
I would like to search all User defined tables in a database for given condition. Say for example my condition is (playerid = 10000052 or tripid = 10000124 ) and TripDtm = '2013-02-03 00:00:00.00 +00:00' I would like to get result from the tables which return at least one record for the condition. How to achieve this? Please do assist.
Have a look at this article - it seems to do what you are looking for Search for a Value Throughout Your Database[^]
It's well known that if all the cat videos and porn disappeared from the internet there would be only one site left and it would be called whereareallthecatvideosandporn.com