I know how to load a CLR DLL in SQL Server and access to its static methods which does not incorporate output parameters in their method signatures but what I cannot realize is how I can use methods which have output parameters.
For example it is strightforward to access Math.dll 's factorial method in SQL server like this:
CREATE ASSEMBLY MathAsm FROM 'C:\Programming\c#\SQLCLRIntegrationExample\assemblies\Math.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS; Go CREATE FUNCTION Factorial(@x FLOAT) RETURNS FLOAT EXTERNAL NAME MathAsm.Math.Factorial; Go
But what if method's signature would be like:
public static int GetInfo(int inputParams, out int outputParams)