Determine Input params at runtime

[JSpicolli]

is there a way to get the names of a proc's params?

 

[snag56]

Do you mean something like:

exec sp_help myproc

 

[JSpicolli]

no.

I mean like being able to iterate thru a collection of input params and get specific param properties such as name and value.

Sorry, I am not usually a SQL developer, so forgive me if my questions are off the wall.

if I can't iterate the params, is there a way to use Case on an insert???

Something like

[COLOR=green]
 /*
   @sOption1 and @sOption2 are input params
 */
[/color]

While @iterator <= @iParamCount
BEGIN
CASE 
 WHEN @iterator = 1 AND Len(@sOption1) > 0 THEN
   INSERT INTO myTable (col1, col2) VALES ('v1', @sOption1)
   WHEN @iterator = 2 AND Len(@sOption2) > 0 THEN
   INSERT INTO myTable (col1, col2) VALES ('v1', @sOption2)
 END
 SET @iterator = (@iterator + 1)
END