SQL Server: Using .NET assemblies (SQLCLR)

0 0 votes
Article Rating

SQLCLR is a technology for hosting of the .NET CLR engine inside SQL Server. Adding an assembly can be a lifesaver sometimes, since the limitations of coding in TSQL stored procedures, triggers or functions are a lot and profound.

As a quick guide, follow these steps:
1. Create a new class library using Studio
New Class Library Project

2. Add the following code

3. After building the assembly, place the dll somewhere that SQL Server can read it and try the following:

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments