Question: why use clr stored procedures?
Answer: CLR Stored Procedures are managed code so it ensures type safety, memory management and so on. It provides Object Oriented Programming capability hence it enables us to use encapsulation, polymorphism and inheritance. A CLR Stored Procedure can be written in C#, VB.NET or any other language supported by the .