Query to find out the some text in the Table data

Accepted answer

Hey check the below links

https://stackoverflow.com/questions/15757263/find-a-string-by-searching-all-tables-in-sql-server-management-studio-2008

http://www.jochenhebbrecht.be/site/2015-04-14/database/searching-a-string-in-all-tables-rows-and-columns-a-database

0

Hi, Please check the below url -

https://www.sqlmatters.com/Articles/Searching%20all%20columns%20in%20all%20tables%20in%20a%20database.aspx

0

Hi Anand,

This is what exactly your looking

here we go

https://www.mssqltips.com/sqlservertip/1522/searching-and-finding-a-string-value-in-all-columns-in-a-sql-server-table/

Let me know if need any help on this.

Thanks

0

You can refer below link

https://www.sqlservercentral.com/scripts/search-all-tables-for-text

https://stackoverflow.com/questions/15757263/find-a-string-by-searching-all-tables-in-sql-server-management-studio-2008

https://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58

0