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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Help in stored procedures

Author  Topic 

sameerv
Starting Member

29 Posts

Posted - 2002-07-19 : 05:09:59
Hi,

How do you declare and manipulate an array(1 or 2 dimensional) data structure within Stored Procedures?

macka
Posting Yak Master

162 Posts

Posted - 2002-07-19 : 06:33:16
SQL doesn't directly support arrays - however there are a few tricks you can use. Check out this link:

[url]http://www.sqlteam.com/item.asp?ItemID=637[/url]

macka.

Go to Top of Page

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2002-07-19 : 06:44:38
Sameer,
There are several ways to handle this issue like Temp. Table, Cursors, Table DataType. For details please go through BOL.

---------------------------
Sandesh - The Messanger
Go to Top of Page
   

- Advertisement -