How to 'copy as sql insert' a selection from the grid?

How to 'copy as sql insert' a selection from the result grid? It's creating all the rows and columns which I don't want. I also don't see an option to copy the results to the clipboard?

Hello. Are you using SQL Assistant SQL Editor IDE or something else?

Example below. This will only include columns that are show in the grid. If your query returns a subset of columns only those columns will be scripted.

I am using the SSMS add-on.

Can confirm OP's issue. If I select 3 columns out of a grid and do the "COPY AS SQL INSERT", it takes all the table columns with it.

Edit:
So you're saying it'll take all the columns in the result grid, so you need to pare it down first before using "COPY AS SQL INSERT"? You cannot highlight the columns you want copied (like your example seems to show is possible)?

In learning about this, I am wondering why the insert into statement is repeated multiple times, rather than:

	Code:
	insert into table (foo, bar) VALUES ('foo','bar'),('fooo,'baz'),(etc...)?

	Mindflux wrote:
	So you're saying it'll take all the columns in the result grid, so you need to pare it down first before using "COPY AS SQL INSERT"? You cannot highlight the columns you want copied (like your example seems to show is possible)?

Correct, it saves the grid data to the script, not selected columns or selected values. In your query you can choose what exactly need to be scripted. This enables you to choose which columns or subset of rows to include, as well as enables to to add computed expressions whose values you want to be scripted too. It's very flexible in that sense.

Mindflux wrote:

In learning about this, I am wondering why the insert into statement is repeated multiple times, rather than:

	Code:
	insert into table (foo, bar) VALUES ('foo','bar'),('fooo,'baz'),(etc...)?

Please wait for a little while. It's coming very soon :-)

huzzah!

The beta version is out. An announcement with download link is in top message in this board.