O'Reilly logo

Programming Microsoft® SQL Server® 2012 by Leonard Lobel and Andrew Brust

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CLR Functions

Let’s take everything we’ve discussed about SQL CLR stored procedures and deployment and apply it to SQL CLR functions. As any programmer knows, a function is a procedure that returns a value (or an object). Mainstream .NET functions typically return .NET types. SQL CLR functions, on the other hand, must return a SqlType. So to start with, you need to make sure that your classes that implement SQL CLR functions import the System.Data.SqlTypes namespace with a using or Imports statement. The SQL Server Database Project C# template for user-defined functions (UDFs) contains the appropriate using statement by default; you will need to add the using statement manually to standard Class Library code.

Once the namespace is imported, you ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required