Overview of integration of CLR with SQL Server

          

Overview of integration of CLR with SQL Server

<<Previous   Next>>

Overview of integration of CLR with SQL Server - March 16, 2009 at 16:45 PM by Amit Satpute

Overview of integration of CLR with SQL Server 

User-defined types and aggregates are written as entire classes. The developer compiles the code and creates an assembly.

The assembly is uploaded into a SQL Server database, where it is stored in the system catalogs using the CREATE ASSEMBLY data definition language (DDL) statement.

Transact-SQL (T-SQL) objects, such as routines, types, and aggregates are then created and bound to entry points in the assembly that has been already uploaded by using the CREATE PROCEDURE/FUNCTION/TRIGGER/TYPE/AGGREGATE statements.

The created routines can be used like T-SQL routines by applications. 

<<Previous   Next>>
 



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring