SQL Server 2008 RegEx CLR使用 [英] SQL Server 2008 RegEx CLR Use

问题描述

好的，我意识到SS 2008没有本地正则表达式功能。我还看到可以使用CLR添加它们。
我在 http://msdn.microsoft.com上找到了正则表达式CLR /en-us/magazine/cc163473.aspx
，但我不知道该如何处理。

OK, I realize that SS 2008 doesn't have native regex functions. I also see that it's possible to add them using CLR. I found the regex CLR at http://msdn.microsoft.com/en-us/magazine/cc163473.aspx , but I don't know what to do with them.

所以我有2个问题。仅当针对两个字段导入记录（一次最多1,000,000，每年最多50,000,000）时，才使用正则表达式。

So I have 2 questions. The regex is only used when importing records (up to 1,000,000 at a time, and up to 50,000,000 a year) against 2 fields.

第一个问题。我可以在我的代码（ASP.NET）中一次手动记录1条记录，我知道这会降低性能，但是不知道有多大。

1st question. I can do it manually 1 record at a time in my code (ASP.NET), and I know it would be a performance hit, but no idea how big of one. Any input on this?

第二个问题。有人可以向我指出有关如何安装我下载的CLR文件的简单分步说明吗？我尝试进行搜索，但是要么没有显示我需要的信息，要么就被其他信息淹没了，找不到我。

2nd question. Can someone point me to a simple step by step instruction on how to install the CLR files I downloaded? I tried doing a search, but that either didn't show the info I needed, or was too buried in other info for me to find it.

谢谢

PS我正在运行SS 2008（不是R2）和VS.NET 2008。

P.S. I'm running SS 2008 (not R2) and VS.NET 2008.

推荐答案

请参见此处的文章完整的教程。

这篇关于SQL Server 2008 RegEx CLR使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！