UDF calling external C++ code inside SQL Server

Question

Suposse I have an UDF in SQL Server 2008:

Create function dbo.ReadXml (@xmlMatrix xml) returns table
as
return
( select
   --SOME C++ CODE
)
go

Is it possible to add a c++ code or call a c++ function inside the UDF?

GSerg · Accepted Answer · 2011-06-02 15:47:30Z

2

Onyl if this C++ function was compiled and installed as an extended stored procedure.
But extended stored procedures are deprecated and will be removed soon.

So your only reliable option is to write a CLR function. It can be a C# CLR function that calls an external C++ dll, or it might be a managed C++ CLR function that would contain your code directly.

edited Jun 2, 2011 at 15:47

answered Jun 2, 2011 at 15:33

GSerg

78.8k18 gold badges173 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

edgarmtze Over a year ago

Ok, so the steps would be: - To have a C# CLR function - This C# function calls external C++ dll.... How would that C# call a C++ dll? I don't undestand well that step...

GSerg Over a year ago

@cMinor By using the DllImportAttribute.

edgarmtze Over a year ago

As you answered, What do you recommend, C# CLR Function, or managed C++ Function?

GSerg Over a year ago

@cMinor Whatever is easier for you to use/maintain. For me it would be easier to have a separate C++ dll, as I'm way too unfamiliar with managed C++. However, having a single managed C++ assembly has an advantage of requiring the lowest permissions (SAFE) because you don't try to load something from outside.

Collectives™ on Stack Overflow

UDF calling external C++ code inside SQL Server

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related