How to create automatically a table populate script from current data in SQL Server?

Question

Is there a tool that allows me to create a sql populate script for a table using its current data?

Answer 1

Old question, but I got to the question before figuring out a way to solve the problem. So I'm just posting the method here in case it might help anyone else.

In SSMS:

1. Right click on db -> "Tasks" -> "Generate Scripts..."
2. Click "Next" and, at "Choose Objects" step, select the specific table
3. Click "Next" and, at "Set Scription Options" step, click "Advanced"
4. Set value for "Type of data to script", depending on what you need
5. Continue to finish