SQLCLR

Stairway to SQLCLR

Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

  • Stairway Step

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.

5 (6)

You rated this post out of 5. Change rating

2020-07-09 (first published: )

25,848 reads

External Article

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

  • Article

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.

2017-09-25

7,840 reads

Blogs

Resetting Git and Abandoning Changes–#SQLNewBlogger

By

I recently had an issue in one of my Git repos, and decided to...

Exploring Window Functions Execution Plans

By

There are quite a few different ways that you’re likely to see window functions...

Exploring Windows Function Execution Plans

By

There are quite a few different ways that you’re likely to see windows functions...

Read the latest Blogs

Forums

Program Code giving duplicate errors where no duplicates exist

By Andre 425568

On our Java Hibernate program it is giving a duplicate value on an insert...

How to get calculated values from a derived(?) table?

By mjdemaris

Here is my filtered dataset: I would like to calculate the time difference between...

sp_server_diagnostics in ErrorLog

By Casper101

I have the following in the SQL Errorlog, that was never there before: sp_server_diagnostics...

Visit the forum

Question of the Day

Disable Memory Grant Feedback Persistence

In SQL Server 2022, how can I disable memory grant feedback persistence?

See possible answers