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
 parameters array

Author  Topic 

juanita
Starting Member

9 Posts

Posted - 2009-03-30 : 09:59:51
Hello!
I have a doubt, I have a database sql server 2005 and am doing some stored procedures to the user from the visual studio can define an application form and therefore create the necessary tables. The easiest way for me to pass the parameters for the stored procedure (taking into account not the number of columns, etc ...) I think I would spend a q array / matrix, but what I have seen for internet no parent in sql server 2000 but in 2005 I have not seen anything.

You could help

Thanks in advance

Juanita

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-03-30 : 11:55:15
You can pass a string delimited list into a single variable and split this in stored procedure:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=122581
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-03-31 : 03:18:15
Also search for Array+SQL Server in google

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -