How to reference a parameter by position passed in

[Paradiddleman]

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 

[#2 · Accepted solution]

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

[#3]

Is there a good reason for that? That sounds just horrible to work with!

But like @olafhelper said, never heard of this... Sorry