Interview answers verified by specialists.

Find interview questions and answers on this website:

See right interview answers on 30 common job interview questions

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.

Do you know that?

Frequently use a to-do list. Next