且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在表的所有列中搜索值?

更新时间:2023-12-01 10:14:22

只需使用一些第三方工具.有几个是 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.