Generate SQL from the Clipboard

Clipboard Scripter is an add-in for SQL Server Management Studio (SSMS).

You can copy-paste tables into Excel, Word, Outlook, or a web page, so why not a SQL script? Clipboard Scripter allows you to script a table from the Windows Clipoard. The scripting includes DDL to define the table structure and DML to populate the table.

Example Usage

As an example scenario, you may need to check a stored procedure's output. Ideally you would be able to insert the results into a table and peform any analysis on that, but in reality this is often not the case. There may be no table for the data or an INSERT INTO EXEC won't work so you end up copying the results into Excel and peform checks there.

Clipboard Scripter has been created to provide a very quick way of creating tables and inserting data. Using the above scenario, rather than export the data to Excel, you could quickly script a table using the output and perform analysis on a temp table.