--Enabling CLR Support in SQL Server 2005 : CLR « CLR « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. CLR
  3. CLR
EXEC sp_configure 'clr enabled', 1
RECONFIGURE WITH OVERRIDE
GO

ALTER DATABASE BookStore
SET TRUSTWORTHY ON








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