Shulou(Shulou.com)06/01 Report--

When clr is enabled, it does not support UI. This is a sql statement, as follows

EXEC sp_configure "clr enabled", 1

Go

RECONFIGURE

To turn off is to change the value to 0.

Start building clr applications

1. Open VS-- > View-> Sql server object Explorer; 2. Connect to a sql server instance 3. Now a data, right-click-> create a new project 4. In the open configuration page, configure information-- > start 5. Solution object Explorer Select Project right-> add New item-- > Select Sqlclr C# stored procedure using System;using System.Data;using System.Data.SqlClient;using System.Data.SqlTypes;using Microsoft.SqlServer.Server Public partial class StoredProcedures {[Microsoft.SqlServer.Server.SqlProcedure] public static void SqlStoredProcedure1 (out string text) {/ / place the code SqlContext.Pipe.Send ("Hello Suhe" + Environment.NewLine) here; text = "my first SqlClr assembly";}} modify code 6. Project right-> release configuration target database connection and database release 1-2 minutes 7. Select publish data Deposit process Click programmability-> Storage course

Right-click-> execute stored procedure OK

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.