Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Table or Arrays as parameters to Stored Procedures
Started 1 month, 4 weeks ago by Inder Neel
Hi, I am a newbie to stored procedure, infact to any Sql language. Can anyone please tell me if we can pass in an array or table as parameter to a stored procedure. Please explain with an example. I am using C# to develop program, so how do I call create array or table in C# with my list and call the store procedure. Thanks inder
Site: MySQL AB - MySQL Forums  MySQL AB - MySQL Forums - site profile
Forum: Stored Procedures  Stored Procedures - forum profile
Total authors: 2 authors
Total thread posts: 2 posts
Thread activity: no new posts during last week
Domain info for: mysql.com

Other posts in this thread:

Peter Brawley replied 1 month, 4 weeks ago
> if we can pass in an array or table as parameter to a stored procedure. No arrays in MySQL, nor is there a table datatype. Pass the name of a table for the sproc to query.
Size: 194 bytes
Customize:  Customize "<b>Reply 1</b>: Re: Table or Arrays as parameters to Stored Procedures :: Stored Procedures :: MySQL AB - MySQL Forums"

 

Top contributing authors

Name
Posts
Inder Neel
1
user's latest post:
Table or Arrays as parameters to...
Published (2009-11-06 12:30:00)
Hi, I am a newbie to stored procedure, infact to any Sql language. Can anyone please tell me if we can pass in an array or table as parameter to a stored procedure. Please explain with an example. I am using C# to develop program, so how do I call create array or table in C# with my list and call the store procedure. Thanks inder
Peter Brawley
1
user's latest post:
Re: Table or Arrays as...
Published (2009-11-06 13:37:00)
&gt; if we can pass in an array or table as parameter to a stored procedure. No arrays in MySQL, nor is there a table datatype. Pass the name of a table for the sproc to query.

Related threads on "MySQL AB - MySQL Forums":

Arrays as Parameters to Stored Procedures?  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Arrays as Parameters to Stored Procedures?
Arrays as Parameters to Stored Procedures?
Passing arrays to mySQL stored procedures  MySQL AB - MySQL Forums - site profile Newbie - forum profile Passing arrays to mySQL stored procedures
Passing arrays to mySQL stored procedures
Arrays in My SQL stored procedures  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Arrays in My SQL stored procedures
Arrays in My SQL stored procedures
How to get parameters from stored procedures  MySQL AB - MySQL Forums - site profile C/C++ - forum profile How to get parameters from stored procedures
How to get parameters from stored procedures
Stored Procedures Parameters (NET Connector)  MySQL AB - MySQL Forums - site profile .NET - forum profile Stored Procedures Parameters (NET Connector)
Stored Procedures Parameters (NET Connector)
Does myODBC supports stored procedures with parameters?  MySQL AB - MySQL Forums - site profile ODBC - forum profile Does myODBC supports stored procedures with parameters?
Does myODBC supports stored procedures with parameters?
Return parameters from Stored Procedures  MySQL AB - MySQL Forums - site profile ODBC - forum profile Return parameters from Stored Procedures
Return parameters from Stored Procedures
How to retreive the parameters of the stored procedures...  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile How to retreive the parameters of the stored procedures fro information_schema
How to retreive the parameters of the stored procedures fro information_schema
Stored Procedures with parameters  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Stored Procedures with parameters
Stored Procedures with parameters
Optional Parameters in Stored Procedures  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Optional Parameters in Stored Procedures
Optional Parameters in Stored Procedures

Related threads on other sites:

Variables, parameters & stored procedures  ASPMessageboard.com - site profile ASP - forum profile Variables, parameters & stored procedures
Variables, parameters & stored procedures
Arrays on stored procedures  Forums - ASP.NET Forums - site profile SQL Server, SQL Server Express, and SqlDataSource Control - forum profile Arrays on stored procedures
Arrays on stored procedures
Parameters & Stored Procedures  dBforums - Database Support Community - site profile DB2 - forum profile Parameters & Stored Procedures
Parameters & Stored Procedures
VB6 Oracle 10 Stored procedures with parameters: New...  Twitter / ITKE - site profile ITKE - forum profile VB6 Oracle 10 Stored procedures with parameters: New Question Created by Hermes68 http://tinyurl.com/5wmooc 1:19 PM Dec 5th from twitterfeed
VB6 Oracle 10 Stored procedures with parameters: New Question Created by Hermes68 http://tinyurl.com/5wmooc 1:19 PM Dec 5th from twitterfeed
How to change Programmability/Stored...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.server - site profile microsoft.public.sqlserver.server - forum profile How to change Programmability/Stored Procedures/Parameters/@original_AlbumID to ...@AlbumID in microsoft.public.sqlserver.server
How to change Programmability/Stored Procedures/Parameters/@original_AlbumID to ...@AlbumID in microsoft.public.sqlserver.server
Stored Procedures parameters and empty nodes. in...  Discussions in microsoft.public.biztalk.general - site profile microsoft.public.biztalk.general - forum profile Stored Procedures parameters and empty nodes. in microsoft.public.biztalk.general
Stored Procedures parameters and empty nodes. in microsoft.public.biztalk.general
Thread profile page for "Table or Arrays as parameters to Stored Procedures" on http://www.mysql.com. This report page is a snippet summary view from a single thread "Table or Arrays as parameters to Stored Procedures", located on the Message Board at http://www.mysql.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity