由网友(抑郁烂人)分享简介：为什么我们使用CLR过程。是否有CLR过程或例如任何意义在哪里CLR过程是唯一的解决办法？Why we use CLR procedures. Is there any significance of CLR Procedures or any example where CLR Procedure is the o...

为什么我们使用CLR过程。是否有CLR过程或例如任何意义在哪里CLR过程是唯一的解决办法？

Why we use CLR procedures. Is there any significance of CLR Procedures or any example where CLR Procedure is the only solution?

推荐答案

假设你想用一个普通的前pression来验证你的一些数据字段的SQL Server中。为了这一天，即使是在SQL Server 2008 R2中，这是仅T-SQL code几乎是不可能的。

Imagine you want to validate some of your data fields in SQL Server using a regular expression. To this day, even in SQL Server 2008 R2, this is virtually impossible with just T-SQL code.

然而，从一个CLR存储过程或存储函数的一点帮助，这将是小菜一碟。

However, with a little help from a CLR stored procedure or stored function, this would be a piece of cake.

T-SQL是非常强的，当涉及到操作的数据集 - 将它用于

T-SQL is very strong when it comes to manipulating sets of data - use it for that.

CLR是非常强的在其他领域，如字符串和日期处理，调用外部服务（WCF，Web服务）。

CLR is very strong in other areas, like string and date manipulation, calling external services (WCF, web services).

所以T-SQL存储过程和CLR存储过程是一个很好的补充 - 挑战每解决一组特定的对方是不是特别好

So T-SQL stored procedures and CLR stored procedures are a nice complement - each solving a specific set of challenges that the other is not particularly good at.