Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rangi
Starting Member
18 Posts |
 Posted - 2002-12-04 : 06:05:02
|
| Is it possible to access parameters by number in a stored procedure?create proc myproc @one int, @two int, @three int as print array_of_params[1]I know there are a number of work-arounds but I am hoping there will be a way to access parameters by number as with other programming languages.Any help would be much appreciated!Rangi |
|
|
mdanwerali
Starting Member
30 Posts |
Posted - 2002-12-04 : 06:31:50
|
can u tell me what exactly the expected output is, means what exactly u want. like it is possible to access parameters by number in a stored procedure but not using Arrarys but using Temperory files #.mention ur problem clearly.anwerquote:
Is it possible to access parameters by number in a stored procedure?create proc myproc @one int, @two int, @three int as print array_of_params[1]I know there are a number of work-arounds but I am hoping there will be a way to access parameters by number as with other programming languages.Any help would be much appreciated!Rangi
|
 |
|
|
Rangi
Starting Member
18 Posts |
Posted - 2002-12-04 : 06:40:52
|
| Temp files sounds like the way to go thanks, I do that.Thanks,Rangi |
|
|
|
|
|
|
Accessing stored proc parameters by number