Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

In the second level of our Stairway to SQLCLR, we look at how to enable the SQLCLR in SQL Server. We then build an assembly, store procedure, and a function that can be called from your T-SQL code.

HTTP Requests Using SQLCLR

Query web APIs directly in SQL Server with its CLR integration

An Easier Way of Transposing Query Result in SQL Server

T-SQL does not have an easy way to transpose a row and a column. Of course, there is the PIVOT statement, but it doesn’t quite accomplish the task. In this article, Darko Martinovic shares another method using a SQLCLR stored prodedure.

Query to Excel Stored Procedure

Transform your query result into an Excel file using this technique.

SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server

SQLCLR is now considered a robust solution to the few niche requirements that can't be met by the built-in features of SQL Server. Amongst the legitimate reasons for avoiding SQLCLR, there is the fear of getting bogged down in code with special requirements that is difficult to debug. Darko takes a real example, extending the features of sp_send_dbmail, to demonstrate that there need be few terrors in SQLCLR.

Practical usage of SQLCLR: Building QueryToHtml function

This article shows a few techniques with SQLCLR to to transform a query result into HTML.

HashBytes Nvarchar(MAX)

SQL SERVER Includes a Hashbytes function, however it's limited to VARCHAR(8000). This can cause a problem when trying to build hashes over wide datasets.

Solution

Expose the C# Hashbytes function using CLR

Soundex - Experiments with SQLCLR Part 3

Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework

Retrieving a Binary File from Your Database

In this second article I provide the means to restore a binary file to its original state.

List CLR Objects in Database

Script lists all the clr objects in the database.