Writting a CLR Stored Proc
With the launch of SqlServer2005, we got the ability to write CLR from any .Net language.
Overview:
The following code-snippet tells how to write a simple CLR Stored Proc with the use of C#.
Step:
1. Start Visual Studio2005 or higher
2. Add new file from File -> New -> File
3. Select Class with C#
4. Mark the name as AStepAheadProc.cs
5. Write the following lines:
/* This Example is a part of different
* examples shown in Book:
* C#2008 Beginners: A Step Ahead
* Written by: Gaurav Arora
* Reach …