Getting started with clrsql

After SQL Server 2005 is released, you can compile the. NET files that can run in SQL Server.Code. Same as IIS, SQL Server 2005 is also. netProgram.
First install sqlserver2005 and Visual Studio 2005. When sqlserver2005 CLR is enabled, the SQL Server Query analyzer should first execute the following statement according to the actual situation.

Exec Sp_configure ' CLR Enabled ' -- View status
Exec Sp_configure ' CLR Enabled ' , 1 -- 1. Enable CLR \ 0 and disable CLR
Reconfigure   With Override -- Follow the prompts (the configuration option 'clr enabled' has been changed from 0 to 1. Run the reconfigure statement for installation .) Run this sentence

You can use Visual Studio 2005 directly for quick development.

During debugging, although sqlserver2005 is used, the default database is still 8.0, and sp_dbcmptlevel 'corp _ 100', 90

Otherwise, there will be a syntax error near Error 1 'external. You may need to set the compatibility level of the current database to a higher value to enable this function. For information about sp_dbcmptlevel, see help. Clr_prgetdocnocom
And:
The CLR function exec sp_configure 'show advanced options', 1 must be enabled.
Go
Reconfigure
Go

Exec sp_configure 'clr enabled', 1
Go
Reconfigure