Install a SQL CLR user defined function

Question

I'm testing out some SQL CLR stuff in VS 2008 and SQL Server 2005, how do I install a user defined function on the database? I built it and have the DLL, but now what?

You would use CREATE ASSEMBLY. One of the first Google hits: msdn.microsoft.com/en-us/library/ms254956(v=vs.90).aspx — Aaron Bertrand
– Aaron Bertrand, Commented Sep 25, 2012 at 1:02
And then CREATE FUNCTION ... EXTERNAL NAME (that example uses a procedure but the syntax is the same). — Aaron Bertrand
– Aaron Bertrand, Commented Sep 25, 2012 at 1:03

Aaron Bertrand · Accepted Answer · 2012-09-25 01:07:58Z

2

You would use CREATE ASSEMBLY. e.g.:

CREATE ASSEMBLY MyAssembly FROM 'C:\path\fille.dll' WITH PERMISSION_SET = SAFE;
GO

And then optional syntax for CREATE FUNCTION that references the function in your assembly (the external name will be dependent on how you structured your code):

CREATE FUNCTION dbo.MyFunction(@param <data_type>)
RETURNS <data_type>
AS EXTERNAL NAME MyAssembly.SqlServerFunctions.FunctionName;

answered Sep 25, 2012 at 1:07

Aaron Bertrand

282k37 gold badges469 silver badges468 bronze badges

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

Collectives™ on Stack Overflow

Install a SQL CLR user defined function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related