Sample Header Ad - 728x90

EXPORT specific columns to INSERT statements

6 votes
3 answers
19711 views
Is there a way to export specific columns and a fixed number of rows from a table to INSERT statements? I am trying to generate these for unit testing based on a large production table so using something like "Generate Scripts" in SQL Server Management Studio is out of the question. There are a few tools that might be able to do this, but something so trivial in MySQL should not be that complex in SQL Server (at least I would hope not).
Asked by Robin (333 rep)
Jun 13, 2013, 11:29 AM
Last activity: Feb 9, 2021, 03:15 PM