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 ...

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial