CLR-Typen des SQL Server-Systems 10.0.1600.22

The SQL Server system has four common language runtime (CLR) types, which allow the server to execute .NET Framework code in the context of a database. These types include:

• CLR stored procedures
• CLR user-defined functions (UDFs)
• CLR triggers
• CLR aggregates

CLR stored procedures are stored in a database and can be called using the EXECUTE statement. These procedures can access external resources such as network resources or files.

CLR UDFs allow users to define custom functions using .NET Framework code. These functions can be used in queries just like regular SQL Server functions.

CLR triggers are event-driven and execute .NET Framework code in response to specific database events such as data changes or schema modifications.

CLR aggregates allow users to define custom aggregate functions using .NET Framework code. These functions can be used in queries to perform complex calculations on result sets.

All CLR types must be registered with the server using the CREATE ASSEMBLY statement before they can be used. Once registered, the CLR types can be accessed just like regular T-SQL objects.