为什么我们使用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.