|
SQLCLR
SQL CLR or SQLCLR (SQL Common Language Runtime) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment. This technology, introduced in Microsoft SQL Server 2005, allow users for example to create the following types of managed code objects in SQL Server in .NET languages such as C Sharp (programming language), C# or VB.NET. *Stored procedures (SPs) which are analogous to ''procedures'' or ''void functions'' in procedural languages like VB or C, *Database trigger, Triggers which are stored procedures that fire in response to Data Manipulation Language (DML) or Data Definition Language (DDL) events, *User-defined functions (UDFs) which are analogous to functions in procedural languages, *User-defined aggregates (UDAs) which allow developers to create custom aggregates that act on sets of data instead of one row at a time, *User-defined types (UDT ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Common Language Runtime
The Common Language Runtime (CLR), the virtual machine component of Microsoft .NET Framework, manages the execution of .NET programs. Just-in-time compilation converts the managed code (compiled intermediate language code) into machine instructions which are then executed on the CPU of the computer. The CLR provides additional services including memory management, type safety, exception handling, garbage collection, security and thread management. All programs written for the .NET Framework, regardless of programming language, are executed in the CLR. All versions of the .NET Framework include CLR. The CLR team was started June 13, 1998. CLR implements the Virtual Execution System (VES) as defined in the Common Language Infrastructure (CLI) standard, initially developed by Microsoft itself. A public standard defines the Common Language Infrastructure specification. During the transition from legacy .NET technologies like the .NET Framework and its proprietary runtime t ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |