SQL Server 中的拼写检查数据 [英] Spellcheck Data in SQL Server
问题描述
我们有一个包含数百个表的大型数据库，这些表中存储了从应用程序最初在海外编写时出现的拼写错误的查找文本.有没有办法对 sql server 中的数据运行拼写检查，以便我们可以快速找到所有这些错误?
We have a large database with hundreds of tables that have lookup text stored in them with spelling errors from when the application was originally written offshore. Is there a way to run a spellcheck on the data in sql server so we can find all of these errors quickly?
推荐答案
- 将您的数据导出到 Excel.
- 将工作表分发给多人以分散工作量
- 让他们运行拼写检查以识别拼写错误的单词.
- 收集不良记录并从数据库创建更新语句.
- 不要将英文拼写很重要的离岸申请.
我应该指出，您可能会使用拼写检查来识别问题，但您希望人眼看到实际数据以及建议的修复.因此，能够分散工作以运行拼写检查很重要.不会有任何完全自动化的解决方案可以捕获所有内容，或者更糟糕的是，它会捕获太多数据并且将数据弄得更糟.
I should have pointed out, you might use the spell check to identify the issues but you want human eyes on the actual data as well as suggested fixes. Thus, being able to spread the work around to run the spell check is important. There won't be any fully automated solution that will catch everything, or worse it will catch too much and muck the data up worse.
这篇关于SQL Server 中的拼写检查数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
