Microsoft® SQL Server 2012 Unleashed

Adding CLR Stored Procedures to a Database

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:

Click here to view code image

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.

The WITH clause is optional, and ...