← Back to blog

Create a script to create SQL insert scripts.

ยท By

Generate row-by-row SQL INSERT scripts that will not time out on constrained hosting tools.

Create a script to create SQL insert scripts.

In SSMS you can ask it to create insert scripts for you, but my hosting company uses some front-end application that does not allow me to do that, and the conventional way to create them timed out due to the amount of rows.

So I created a script that will create individual lines that will not time out.