If you’ve already created and compiled a CLR stored procedure, the next step is to install that CLR procedure 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 load it into SQL Server by creating an assembly. The syntax for the
CREATE ASSEMBLY command is as follows:
CREATE ASSEMBLY AssemblyName [AUTHORIZATION LoginName]FROM StringPathToAssemblyDll[WITH PERMISSION_SET (SAFE | EXTERNAL_ACCESS | UNSAFE) ]
AssemblyName is the name of the assembly, and
StringPathToAssemblyDll is the path to the DLL. The path can be a local path, but often this path is a network share.
WITH clause is optional, and ...