I'm not sure how many total weeks of my life I've spent on data import. Many. Maybe Hundreds. Also, every new project needs test data and usually we'll write INSERT INTO blah blah full scripts again and again. Here's a way to slightly reduce the amount of text that needs to be written/sent to the server AND make your scripts cleaner. Available Sql Server 2008 and up.