Lets say I have the following signature for a CLR Stored Proc or UDF:
[Public] public static void RaisError( string message, short severity, short state, params object args)
The generated DDL is
CREATE PROCEDURE [dbo].[RaisError] @message [nvarchar](4000), @severity [smallint], @state [smallint], @args /* Error: Unsupported type. */ AS EXTERNAL NAME [SqlSaturdayClr].[StoredProcedures].[RaisError];
I can manually write DDL to reference the stored procedure with any number of variables, defaulting them all to null. However, is there a T-SQL way to say "this stored procedure has a variable number of arguments" in the same way as
From this codeproject article it seems that extended stored procs intrinsically have a varariable number of variables and you have to enforce variable length in the code. Is my only option to use an extended stored procedure?