It's possible to use an array variable in a stored procedure

[ejanakieff]

I want to know if it's possible to create a temporal array in a Stored Procedure or in an User Function.

And if it's possible, how can I do it.

Thanks,
Eva Janakieff

 

[Kolt]

u can't
but why do u need arrays? u can create temporary tables - it's much more convenient..
create table #t1 (
f1 int,
.....
)

 

[Jamfool]

You could have a look at this

http://www.algonet.se/~sommar/arrays-in-sql.html

not sure if its any use to u tho