Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

Insert an entire array into a SQL table

How can I insert an entire array into a SQL table without looping through the Array. I am using VB6 and SQL server 2000 - Thanks!!
0
dmwilson34
Asked:
dmwilson34
1 Solution
 
Mikal613Commented:
Make a Comma Deleimited Line with all your values

INSERT INTO sal_emp
    VALUES ('Bill',
    '{" & YourLine & "})'
0
 
dancebertCommented:
Is the array one dimensional?  
Do you want each element of the array to become a record?
Do you want each element of the array to become a field in a record?
0
 
CyrexCore2kCommented:
If the array is dynamic in size you will have to loop through it.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now