array to stored procedure ? possible ? 
Author Message
 array to stored procedure ? possible ?

I want to form (from ASP page) two strings: One with colomn names and Second
with values that I want to insert, and pass to stored procedure as Input
parameters. I have tried to accomplish that but I always get an syntax
error. SP Code is:


AS


GO

Where is mistake ?
Also I tried to form the string and execute it,


but i do not know how to execute it !

Thank you all,
Marko Simic



Fri, 04 Apr 2003 03:00:00 GMT
 array to stored procedure ? possible ?

Marko,

You can execute such strung using EXEC. Something like:




(I would create one proc per table, though....)
--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.
FAQ at: http://www.sqlserverfaq.com


Quote:
> I want to form (from ASP page) two strings: One with colomn names and Second
> with values that I want to insert, and pass to stored procedure as Input
> parameters. I have tried to accomplish that but I always get an syntax
> error. SP Code is:

> CREATE PROCEDURE sp_test



> AS


> GO

> Where is mistake ?
> Also I tried to form the string and execute it,


> but i do not know how to execute it !

> Thank you all,
> Marko Simic



Fri, 04 Apr 2003 03:00:00 GMT
 array to stored procedure ? possible ?
Why would you "create one proc per table..." it sounds "too messy"
Better for performance or more reliable or something else?

and one more question that i already post in this NG

From the aspect of performance: Is it better to make a component to do all
Loops, Stored proceudres calls, result collects, inserts, updates etc etc
and ONLY to pass parameters to initialized component by ASP OR
is it better to do all that job by ASP and skip making component(s).

Time which I gonna spend on making a component is not relevant in this
story.

I am using VB and/or Builder C++

Thank you,
Marko Simic



Fri, 04 Apr 2003 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. How to pass an integer array/userdef type array into an Oracle Stored procedure

2. Arrays of texte in stored procedures

3. how to send an array into stored procedure

4. Can arrays be used in stored procedures?

5. Passing a varying array to a stored procedure variable

6. Passing arrays to stored procedures

7. Passing an array to a stored procedure

8. passing arrays into stored procedures

9. passing arrays into stored procedures

10. Sending an array to a Store Procedure

11. Stored Procedures & Arrays

12. Stored Procedures & Arrays


 
Powered by phpBB® Forum Software