I would like to export a ad hoc Select query result sets from SQL Server to be exported directly as Insert Statements.
I would love to see a Save As option "Insert.." along with the other current available options (csv, txt) when you right-click in SSMS. I am not exporting from an existing physical table and I have no permissions to create new tables so the options to script physical tables are not an option for me.
I have to script either from temporary tables or from the result set in the query window.
Right now I can export to csv and then import that file into another table but that's time consuming for repetitive work.
The tool has to create proper Inserts and understand the data types when it creates values for NULL values.