在表的所有列中搜索值? [英] Search all columns of a table for a value?

问题描述

我一直在寻找答案，但我能找到的只是人们询问如何在数据库中搜索所有表的所有列以获取值.我只想搜索特定表的所有列.人们为所有表格问题提出的代码很复杂，我很难弄清楚它究竟在哪里搜索特定表格.有人可以帮我吗?谢谢

I've looked for an answer to this, but all I can find is people asking how to search all columns of ALL tables in a database for a value. I just want to search all columns for a specific table. The code people have come up with for the all tables question is complicated and hard for me to figure out where exactly it's searching a specific table. Can somebody help me out? Thanks

推荐答案

只需使用一些第三方工具.有几个是 100% 免费的，其中任何一个都不会出错，因为它们会为您节省大量时间.

Just use some third party tool. There are several that are 100% free and you can’t go wrong with any of these because they will save you a ton of time.

ApexSQL Search(搜索架构和数据)，SSMS 工具包(搜索架构和数据，但对于 SQL Server 2012 不是免费的)，SQL 搜索(仅搜索数据).

ApexSQL Search (searches both schema and data), SSMS Toolpack (searches schema and data but not free for SQL Server 2012), SQL Search (searches data only).

坦率地说，我真的不明白为什么即使是非常有经验的 DBA 也不愿意为此编写脚本，如果他们可以免费使用一些可以完成这项工作的工具.

Frankly, I don’t really understand why even very experienced DBAs bother writing scripts for this if they can use some tool for free that will do the job.

这篇关于在表的所有列中搜索值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！