ASP.NET Forum

**bejbika** · 07:57 AM

Can anybody tell me how do I insert 100 new records at once into a table in sql 2k? I need all the help I can get and I really apprishiate it!
p..s - sorry for my bad english

**Kyrnt** · 06-23-2004, 10:16 AM

In ASP, the best way to do it is by simply making 100 insert calls. It is not very sexy, but I am not aware of any SQL syntax which allows you to perform multiple inserts within a single SQL statement.

**bejbika** · 06-23-2004, 10:33 AM

Thanx a lot! Im new at all this, so i kinda need all the help i can get, so i guess i ll be posting alot more questions

**Kyrnt** · 06-23-2004, 10:44 AM

No problem bejbika -- glad we could help you. Keep those posts coming!