SQL Server issue

Hello All,

Can you please help us to find out the some text in the Table data.

Let say i have text like “DPSS” I need to find this text in the enter tables in the Database using SQL Server is there any query to get these details in the entire all tables.

please help us.

Thanks
Anand

Well, if I understand correctly you want to search for a string in all of the database tables. My approach would be:

  1. Write 1 stored procedure that does a search through the entire schema, store the results in a hash/temporary table and query the #table for the results. (you can find examples just by doing a simple google search)
  2. Execute the stored procedure from code
.NET Foundation Website | Blog | Projects | Code of Conduct