SQL CLR: Difference between revisions

Revision as of 09:34, 6 November 2017

Revision as of 09:35, 6 November 2017

Line 7:

*[[User-defined function]]s (UDFs) which are analogous to functions in procedural languages,

*[[User-defined aggregate]]s (UDAs) which allow developers to create custom aggregates that act on sets of data instead of one row at a time,

*[[User-defined type]]s (UDTs) that allow users to create simple or compwlexcomplex data types which can be serialized and deserialized within the database.

The SQL CLR relies on the creation, deployment, and registration of [[Assembly (CLI)|CLI assemblies]], which are physically stored in managed code dynamic load libraries (DLLs). These assemblies may contain CLI namespaces, classes, functions and properties.