How to reference a parameter by position passed in

Occasional Visitor


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. 





2 Replies
best response confirmed by Louis Davidson (MVP)
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.

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

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