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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 is there an array instead of a cursor or tempdb?

Author  Topic 

landau66
Yak Posting Veteran

61 Posts

Posted - 2008-07-21 : 04:19:51
hello everyone!

i am looking for an alternative for cursor and tempdb. is there something like that in sql server 2005? maybe something like an array in which i can put my data.

thank u very much in advance and greetings from vienna

landau

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-21 : 04:21:41
What are you trying to achieve here ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-21 : 04:21:46
You can use XML to pass an array of values to a stored procedure.
See http://www.sommarskog.se/arrays-in-sql.html



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2008-07-21 : 07:45:20
BTW. Peso's link covers all the possible storage containers and methods you could want. Not just XML so give it a try.

-------------
Charlie
Go to Top of Page
   

- Advertisement -