0

I have a SQL Server database with a lot of stored procedures. I use the system stored procedure sp_help to view information about these stored procedures.

There are a lot of stored procedure that have type = 'stored procedure' in information view, but some of the stored procedures have type 'assembly stored procedure'.

  1. What is the difference between them?
  2. And what is the purpose of using that type of stored procedure?
Thom A
  • 88,727
  • 11
  • 45
  • 75
VladimirK
  • 27
  • 6

1 Answers1

2

In SQL Server you are able to create SQL CLR objects, which basically allows you to create .NET routines (functions, stored procedures, triggers and even custom aggregates).

For example, you can use .NET to implement regex functions, or in the past, when STRING_AGG did not exist, to create custom aggregate for string concatenation.

Thom A
  • 88,727
  • 11
  • 45
  • 75
gotqn
  • 42,737
  • 46
  • 157
  • 243