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)
 ARRAYS IN STORED PROCEDURES

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-11 : 00:44:36
Vaishnavi writes "I need to insert a single record with 10 fields into an table.
I am passing the 10 fields as array. I loop thru the array and get the 10 individual values from the array. But i dont want it to store it in individual variables as I get the field values. I want to insert the record after i loop through. How do i do it"

dsdeming

479 Posts

Posted - 2002-03-11 : 08:10:16
Have you looked at "Passing a CSV or Array to a Stored Procedure" in the FAQ? I think it will solve your problem.


Go to Top of Page
   

- Advertisement -