Loading the Assembly Into SQL Server : CLR « CLR « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. CLR
  3. CLR
CREATE ASSEMBLY assembly_name
[ AUTHORIZATION owner_name ]
FROM { '[\\computer_name\]share_name\[path\]manifest_file_name'
  | '[local_path\]manifest_file_name'|
{ varbinary_literal | varbinary_expression }}
[ WITH PERMISSION_SET = { SAFE | EXTERNAL_ACCESS | UNSAFE } ]








29.2.CLR
29.2.1.Converting SQL Server to CLR Data Types
29.2.2.--Enabling CLR Support in SQL Server 2005
29.2.3.Loading the Assembly Into SQL Server
29.2.4.Creating the CLR Stored Procedure
29.2.5.Creating a CLR Scalar User-Defined Function
29.2.6.Creating a CLR Trigger