Is it possible to insert multiple records with ONE insert?

[Sina]

Hello everyone,

Is it possible to insert several records with one insert statement in Sybase 12?

Basically instead of inserting every record with one insert in to table A, I wanted to know if I can write the insert statement in a way, so that I could insert multiple records with one insert.

i.e I have one million records that I have to insert everyso often. but it takes a long time with the insert per each record.

Thank you all.

 

[RajD]

Hi Sina,

Where do you insert the records FROM?
1. From another table?
Then I think you know how to do multiple insert
2. From a text file?
If yes, have you tried "bcp"?
3. Manually?
I don't think so. Because you have mentioned 1 million
records.

Let me know. Maybe we can get the solution for you.

RajD

 

[RajD]

Hi Sina,

Where do you insert the records FROM?
1. From another table?
Then I think you know how to do multiple insert
2. From a text file?
If yes, have you tried "bcp"?
3. Manually?
I don't think so. Because you have mentioned 1 million
records.

Let me know. Maybe we can get the solution for you.

RajD