FR: Script grid results

Is there a way we can select rows or columns from the grid results and script those to an insert statement so that it'll wrap the data in quotes and commas for insert into scripting or other scripting needs ? There are tools that do this for SSMS (SSMS tools pack or RedGate sql prompt). Neither of which are free or I use.

Maybe there's already a way to do it and I don't know? SQL Assistant is so feature packed sometimes I miss things.

Examples:
http://www.ssmsboost.com/Features/ssms-add-in-results-grid-script-results
http://www.sqlservercentral.com/blogs/never_say_never/2011/02/13/ssms_2D00_tools_2D00_pack_2D00_script_2D00_grid_2D00_results/
https://www.cathrinewilhelmsen.net/2016/03/02/redgate-sql-prompt-results-grid-features/

You cannot select a subset of cells and have only selected cell scripted. But you can certainly script the result set of simple queries. By simple I mean results of quick data preview and simple SELECT queries like
SELECT * FROM myTable WHERE colA < 100

Right-click the data-grid and choose Save as Script menu. Choose output options and it will save as script containing INSERT commands for the rows in the data-grid. The target database dialect depends on the selected Options. The script can be saved to a file or written to a new new code pane, from which with one-click you can copy it to the editor

"Save as Script" is greyed out for me.

I did a simple select (no joins)...

the where was WHERE WSID='MyWSID'

if I take the where out, the save as script is usable.. but now I have far too many results to sift through?

*Edit: Doesn't matter what I'm selecting for the WHERE. It greys out the Save as.

Are you running 9.0.176 or an older version?
Does the table have primary key?
Is that menu enabled when you right-click that table in database explorer and select "Quick Data Preview" command?

	SysOp wrote:
	Are you running 9.0.176 or an older version? Does the table have primary key? Is that menu enabled when you right-click that table in database explorer and select "Quick Data Preview" command?

Running 9.0.176
Yes PK
Yes

It's only when I add a where clause to my TSQL statement where the right click option goes out.

Weird, I tested it with several tables and it doesn't seem to work consistently. For some tables it works with a WHERE clause, for some it doesn't. I also observed that whenever Save as Script is disabled, the Edit mode is disabled too. But when I use Quick Data Preview or drop the WHERE clause, then it works for all of my tables. I'm going to ask for more help on this one, and will get back to you early next week.

I tested this one and experienced rather erratic behavior. I was unable to find any tables that would leave Save As Script enabled when querying with WHERE but figured out that (not) having a statement terminator (;) affects the state of mentioned context menu item.

	gemisigo wrote:
	I tested this one and experienced rather erratic behavior. I was unable to find any tables that would leave Save As Script enabled when querying with WHERE but figured out that (not) having a statement terminator (;) affects the state of mentioned context menu item.

That's odd (and I can comfirm) that leaving the (;) off on a generic select with no where works, add the semi colon and suddenly you can't script it at all.

On top of the other odd behavior.

It appears this one is still open.

	Mindflux wrote:
	It appears this one is still open.

You are correct. The fix for this issue is still developing.

SysOp wrote:

	Mindflux wrote:
	It appears this one is still open.

You are correct. The fix for this issue is still developing.

The fix for this issue is available in the latest released build 9.0.194