Forum Discussion

Paradiddleman's avatar
Paradiddleman
Copper Contributor
Jan 26, 2023

How to reference a parameter by position passed in

Hi 

In SyBase I can reference a parameter passed into a stored proc by its position passed in, something like '%1!' this would tell me the value of the first parameter passed in to the proc, '%2!' would tell me the second parameter passed in.

Is there a way to do this in ms sql. 

I need to convert a lot of procs that have this in the sybase code. 

 

Thanks 

 

Steve 

  • No, it's not possible, even because it make no sense: The parameter name is during development known; so what could that be good for? Makes really no sense.

    Olaf
  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    No, it's not possible, even because it make no sense: The parameter name is during development known; so what could that be good for? Makes really no sense.

    Olaf

Resources