SQL Server UDF Using C#

Question

How can I create a User Defined Function UDF In SQL Server, I was looking for an example, Could you provide a very simple example using C#?

Axarydax · Accepted Answer · 2011-01-19 14:38:29Z

2

It's not possible. SQL Server 2008 contains SQL CLR runtime that runs .NET languages.

answered Jan 19, 2011 at 14:38

Axarydax

16.7k22 gold badges95 silver badges157 bronze badges

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

3 Comments

edgarmtze Over a year ago

So I can only use Visual Basic, C#?. In other SQL version, like 2000, or 2005 Is it possible?

Axarydax Over a year ago

Do you need it? If it's a function, it might be called for lots of rows and lots of times, and this approach might be slow... And you might get memory leaks and crash SQL Server. If you absolutely must call unmanaged code (C,C++) from inside SQL Server, call the code via P/Invoke from the C#/VB.NET assembly. See this thread for more info: social.msdn.microsoft.com/Forums/en/sqlnetfx/thread/…

edgarmtze Over a year ago

I was planning to do an aggregate function, but for testing yield, i need to use a UDF.

Collectives™ on Stack Overflow

SQL Server UDF Using C#

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related