I like the script as insert, but what i would like is the ability to generate and insert for the line. Not into a temp table, but into the original table. This would be useful for copying data between databases, or more commonly if i want a new row, but just a few columns different. I could generate the insert, then change the column data as needed.

Table variables are also written to the tempdb, but don't have indexes. Table variables assume there is only 1 row in the table prior to SQL Server 2014 and 100 rows with SQL Server 2014 and higher.

How about an option to generate this using a table variable rather than a temp table? Or have an if exists then drop so that it won't barf if run twice?

Create a shortcut that will run the hightlighted SELECT statement and create INSERT statements from the output in a popup window or in the Text Results pane.

Thanks David for the suggestion but I just tried the plugin and it involves more steps unlike having it as an option in the result grid when you right click on it.

Additional, you need to have a separate window and execute the script again to have the desired output.

Lastly, if you could see the SSMSBoost functionality regading this feature, there's more option and flexibility available.

I think this would be a good feature within SQL Prompt.

There's a free SSMS add-in called TSQL Flex that might help here https://github.com/nycdotnet/TSqlFlex