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?

Today, there are about 53 million Americans freelancing, which is about 34% of the total workforce Next


Fast Payments
Payoneer sing up to get free