Advantages of CLR procedure over T-SQL procedure

• The use of the CLR procedure makes it possible to do the complex database operations without having an in-depth knowledge of T-SQL.
• It also enables focusing the business layer towards the database in orderto increase the server performance by avoiding unnecessary server trips.
• Also, with the help of the .NET Base Class Libraries, the complex logical operations can be effectively performed.
• It deals with automatic garbage collection, memory management, exception handling, etc. due to which it is known as Managed Procedure.
• The concepts of the OOP can also be applied.

It provides the ability to leverage the features of .NET Code Access Security (CAS) to prevent assemblies from performing certain operations