Is there a limit on the number of sql statements in a single transaction?
posted 8 years ago
Hello. I'm looking to insert a large set of data into a primary table but then n number of data subsets related to the primary data into a secondary table. Are there any known limits on the number of SQL inserts allowed if i wrap it all into a single transaction? Thank you.
I have used transactions which contain several thousand records with SQL Server. But why don't you try out your proposed application with your proposed database to see what actually happens? It's called "stress testing".