Using CLR planning in your project

1. Create your own project

2, the "solution ... → participate → →c#→ database →sql server project, for example, as seen in:

3. Select Operational Database

4. Create a stored procedure

5. Code (see: CLR Stored procedures)

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 StoredProcedure1 ()    {        //place code here    }};

6. Enable CLR integration

sp_configure ' clr enabled ', 1GORECONFIGUREGO

7. Deployment

Right-click the database project name (SqlServerProject1) → configuration.

Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.

Using CLR planning in your project