CLR Function Vs SP Vs Trigger Vs UDT in SQL Server

CLR (Common Language Runtime) function
A function that is created by referencing a SQL Server assembly. The implementation of the CLR function is defined in an assembly that is created in the .NET Framework CLR.




CLR (Common Language Runtime) stored procedure
A stored procedure that is created by referencing a SQL Server assembly. The implementation of the CLR stored procedure is defined in an assembly that is created in the .NET Framework CLR.




CLR (Common Language Runtime) trigger
A DML trigger or DDL trigger that is created by referencing a CLR assembly. The implementation of the CLR trigger is defined in an assembly that is created in the .NET Framework CLR.




CLR (Common Language Runtime) user-defined type
A user-defined data type that is created by referencing a CLR assembly. The implementation of the CLR user-defined type is defined in an assembly that is created in the .NET Framework CLR.

No comments: