Interview answers verified by specialists.
Find interview questions and answers on this website:
• 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.