Search string value in all Columns and Tables in SQL Server

anand.ma...

SOLVED CLOSED ACTIVE ANSWERED
User: anand.mand
Posted: on Aug 06, 2019 12:27 AM
Forum: SQL Server
Replies: 3
Views: 2905

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

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyis...

0 3

Reply
User: pandeyism
Replied: on Aug 06, 2019 04:49 AM
Report

Hi anand.mand,

Refer below links -

https://stackoverflow.com/questions/1796506/search-all-tables-all-columns-for-a-specific-value-sql-server

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Search string value in all Columns and Tables in SQL Server

Company

Explore

Follow us

Contact Us