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
Last activity: Feb 9, 2021, 03:15 PM