Microsoft® SQL Server 2012 Unleashed

Adding CLR Functions to a Database

If you’ve already created and compiled a CLR function, your next task is to install that CLR function in the database. The first step in this process is to copy the .NET assembly to a location that SQL Server can access, and then you need to load it into SQL Server by creating an assembly. The syntax for the CREATE ASSEMBLY command is as follows:

Click here to view code image

CREATE ASSEMBLY AssemblyName [AUTHORIZATION Owner_name]FROM  { <client_assembly_specifier> | <assembly_bits> [ ,...n ] }[WITH PERMISSION_SET = (SAFE | EXTERNAL_ACCESS | UNSAFE) ]

AssemblyName is the name of the assembly. client_assembly_specifier specifies the local path or network location where the assembly being uploaded is located and ...