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

advanced SQL tutorials

Dear All,
Can you suggest a good book or set of websites which have advanced SQL tutorials for SQL server? Got the basics but looking to build on my knowledge.
...cause knowledge is power...Here are some books

http://www.sqlteam.com/store.asp

And read every post here, and over at sql team.

Use Books online to try and figure out a posters question in Query Analyzer. Most often than not you will see someone answer the question.

Good Luck|||You might want to be a bit more specific. SQL Server has components that cover a broad range of topics. Are you a developer seeking to increase your knowledge of T-SQL and ADO? Are you a DBA seeking the best practices for securing your data and performance tuning? Are you a business analyst looking to learn MDX and OLAP?

Lots of sites to browse. Google is your friend.

Regards,

hmscott|||You might want to be a bit more specific. SQL Server has components that cover a broad range of topics. Are you a developer seeking to increase your knowledge of T-SQL and ADO? Are you a DBA seeking the best practices for securing your data and performance tuning? Are you a business analyst looking to learn MDX and OLAP?

Lots of sites to browse. Google is your friend.

Regards,

hmscott

Sorry for late reply and thanks for recomendations! Yes trying to learn more about complex queries with t-sql and db design and implementation for real life apps, had DB modules at Uni but it seems like hardly anything compared to the problems I face now in my job!