Adding multiple records

[Anon]

Is it possible to take a list say of email addresses e.g. [e-mail],[e-mail],[e-mail]
and add them to a table in one SQL statement??
Where the table would have fields of

Email_address
active
date_added

or would I have to convert the list into an array and cycle through that and add each individually???

[Anon]

I'm using SQL server btw.

[amcgrath]

cycle through the array....

[[deleted]]

The 'real' SQL standard does not allow you to insert multiple records with one query, but some databases have extra functions that allow tricks like that. For example, in MySQL you can add several sets of values tot eh insert statement;
INSERT INTO table VALUES(1,2,3),(4,5,6)

Search the manual of your database, there may be a trick like this available.

Note: if you want to prevent future compatibility problems, then use only the functions that are generic!