Wednesday, January 2, 2013

Use CLR assemblies in SQL!

  1. See the assemblies Object Explorer at: Your Server > Databases > Your Database > Programmability > Assemblies
  2. This is an example of calling the assemblies from SQL like so:
    WITH EXECUTE AS CALLER
    AS
    EXTERNAL NAME [NameOfAssembly].[NameOfClassWithinAssembly].
       [NameOfMethodWithinClass]
    GO

No comments:

Post a Comment