Inserting Records 5000 At A Time

[mark1110]

Hi,

I have 2 sybase tables, Address and Temp_Address. I need to insert all records in Address into Temp_Address. However, I don't know how many records I have in the Address table and I need to insert them 5000 records at a time then do a commit. Has anyone done this who can help me out?


Thanks,

Mark

 

[sybasedbuser]

Stored Procedures can be written to accomplish this.
Use cursor and also commit after reaching 5000 rows.