CLR Stored Procedure and Creating It Step by Step

-- Execute following statements and conncect "DbForClrDemo" database from your application

--Part I
--Create a new databse for demo
CREATE DATABASE DbForClrDemo

--Use database
USE DbForClrDemo

--Create table for CustomerSalesInformation
CREATE TABLE [dbo].[CustomerSalesInformation](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[Sales] [decimal](18, 2) NOT NULL DEFAULT ((0)),
 CONSTRAINT [PK_CustomerSalesInformation] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

--Insert dummy data to CustomerSalesInformation table
INSERT INTO [dbo].[CustomerSalesInformation]([Name], [Sales]) VALUES ('Virat Kothari', 50000)
INSERT INTO [dbo].[CustomerSalesInformation]([Name], [Sales]) VALUES ('Dhruval Shah', 5000)
INSERT INTO [dbo].[CustomerSalesInformation]([Name], [Sales]) VALUES ('Urvish Sheth', 15000)
INSERT INTO [dbo].[CustomerSalesInformation]([Name], [Sales]) VALUES ('Rakesh Bajania', 25000)
INSERT INTO [dbo].[CustomerSalesInformation]([Name], [Sales]) VALUES ('Dhaval Shah', 150000)
INSERT INTO [dbo].[CustomerSalesInformation]([Name], [Sales]) VALUES ('Amit Shah', 250000)

--Following statements can be used once the Assembly is deployed to the database

--Part II
--Enable CLR Stored Procedure in database
sp_configure 'clr enabled', 1

--Run following statuement to take effect of above statement
RECONFIGURE

--Now execute our CLR Stored Procedure. Remember "ClrDemo" is name of our Stored Procedure
EXEC [dbo].ClrDemo