Advantages of using CRL Sprocs over T-SQL Sprocs?

I am wondering what the advantages of using CRL Sprocs over T-SQL sprocs and what not.

Looking for such comparison and articles on websites resulted in only "how to create CRL sprocs" but none of them were talking about what they are used for in what situations.

I would really appreciate it if you guys can post comments, links and external articles.

Thank you in advance.

? The book referenced in my signature has some guidelines. But basically: - Use T-SQL routines for all normal data access, including both SELECTs and DML operations. - Use SQLCLR routines when you need more complex logic that might be difficult to express in T-SQL. Also, SQLCLR routines are good when you need high performance math or string operations. -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <DontBotherMeWithSpam@.discussions.microsoft.com> wrote in message news:781b0860-5d01-4caf-a357-6307b7e0e621@.discussions.microsoft.com... I am wondering what the advantages of using CRL Sprocs over T-SQL sprocs and what not. Looking for such comparison and articles on websites resulted in only "how to create CRL sprocs" but none of them were talking about what they are used for in what situations. I would really appreciate it if you guys can post comments, links and external articles. Thank you in advance.sql