Do you know that? IT systems support professionals, marketing professionals and editors are more likely to earn less when they go solo. next

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.