C#

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,808 reads

Blogs

Query deadlock info in Azure SQL DB

By

A couple of weeks ago, a developer came to me and wanted to know...

MSSQL Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database

By

Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...

Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines

By

When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...

Read the latest Blogs

Forums

Flexable/Effective means to join the Nth record

By YSLGuru

I have no doubt this has been covered many times and has many answers...

Contained Availability Groups and Replication

By SQLPug

Hi, I have a couple of questions around contained AOAG: Is it still the...

Canot connect to Prod1

By ramana3327

Tried using SQL authentication but getting below error. A connection was successfully established with...

Visit the forum

Question of the Day

Sensitivity Ranks

I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?

ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price,
    dbo.sales.discount
WITH (
    LABEL = 'Highly Confidential',
    INFORMATION_TYPE = 'Financial',
    RANK = 'INTERNAL ONLY'
);

See possible answers