Wrox Programmer Forums
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 30th, 2009, 10:03 AM
Registered User
  
Join Date: Mar 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default parameters array
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 an array, 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
 
Old March 30th, 2009, 10:07 AM
Friend of Wrox
  
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default
Sorry, can you clarify your question?
__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
 ================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
 ================================================== =========
I know that CVS was evil, and now i got the proof.
 ================================================== =========
 
Old March 30th, 2009, 10:13 AM
Registered User
  
Join Date: Mar 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default parameter array
If I want to know if sql server 2005, there are arrays, to create a stored procedure that I pass the array in the number of columns and column type that vain to form the table. As I do not know beforehand how many columns will be I think the best way.

Thank you
 
Old March 30th, 2009, 09:01 PM
Friend of Wrox
  
Join Date: Oct 2006
Posts: 475
Thanks: 0
Thanked 9 Times in 9 Posts
Default Pass 1, 2, or 3 dimensional "arrays" in SQL Server
Yes... there is a way and it works well in both SQL Server 2000 and 2005. Please see the following article...

http://www.sqlservercentral.com/articles/T-SQL/63003/
__________________
--Jeff Moden





Similar Threads
Thread Thread Starter Forum Replies Last Post
Convering a String Array to an Integer array nkrust C# 9 November 17th, 2010 12:02 PM
Go from 2d Array to 1d array without defining type OneQuestion General .NET 1 January 10th, 2008 11:13 AM
error when sorting an Array of Array nancy VBScript 2 February 17th, 2005 12:57 PM
Assigning value to array within array janise Beginning VB 6 23 January 11th, 2005 11:38 AM
Passing php array values to javascript array gkrishna Pro PHP 0 November 6th, 2004 03:20 AM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.