Forum Discussion
Paradiddleman
Jan 26, 2023Copper Contributor
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
- Is there a good reason for that? That sounds just horrible to work with!
But like olafhelper said, never heard of this... Sorry - olafhelperBronze ContributorNo, 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