dotnet general: insert multiple rows -- dotnet general

Re: insert multiple rows

Tem
1/30/2008 11:48:33 PM

I know it only inserts one row. I was hope that someone can help me change
it to insert multiple rows

Thanks

[quoted text, click to view]

Re: insert multiple rows

DDD
1/31/2008 12:54:21 AM

[quoted text, click to view]

Re: insert multiple rows

Cor Ligthert[MVP]
1/31/2008 7:19:14 AM

Tem,

This is the SQL script which is inserting a row in the SQL server.

In dotnet you can use this by using a SqlCommand.

There are plenty of these from which is the most easy one for this
SqlCommand.ExecuteNonQuerry

However have a look in the newsgroup

Microsoft.public.dotnet.framework.adonet

Where are people more specialized about your question.

Cor

"Tem" <tem1232@yahoo.com> schreef in bericht
news:%23oeDWA9YIHA.2000@TK2MSFTNGP05.phx.gbl...
[quoted text, click to view]

Re: insert multiple rows

Uri Dimant
1/31/2008 8:48:14 AM

Tem
SQL Server does NOT support arrays. See Erland's great article
http://www.sommarskog.se/arrays-in-sql.html

[quoted text, click to view]

Re: insert multiple rows

Anith Sen
1/31/2008 11:01:24 AM

There is no built in support in SQL Server to insert multiple rows directly.
With t-SQL, you have a few options:

1. Write your insert statement as INSERT.. SELECT ...UNION... SELECT..
UNION...
2. Generate a series of insert statements from your client programming
language and execute them on the server.
3. Fake an list or an array with your sets of values: You can do this in a
variety of ways, Check out the like Uri provided or see:
www.projectdmx.com/tsql/sqlarrays.aspx

--
Anith

Re: insert multiple rows

Marc Gravell
2/1/2008 10:07:27 AM

Personally, for 3 rows I'd just call it 3 times; however, if you are
on SQL Server 2005 or above you can use xml very effectively to wrap
multiple logical entities into a single call.

If the 3 is actually 3000, then there are other options - for example,
using SqlBulkCopy to throw the data (at high speed)into a staging
table, and have an SP that moves the data into the regular table (I
don't recommend bulk-insertion into "live" tables).

Marc

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the dotnet general group.