Comments
Sort by recent activity
Something I find handy with SQL Prompt is the "Script as Insert" feature. When you get the results back from running a query, you can highlight the entire data set (or just the rows you care about), then right-click and choose "Script as Insert." This will scaffold out the insert statement for you inside of SSMS. This is handy for scenarios such as generating a script to be used for re-seeding data for an integration test without having to write that insert by hand. / comments
Something I find handy with SQL Prompt is the "Script as Insert" feature. When you get the results back from running a query, you can highlight the entire data set (or just the rows you care about...
Another handy one from SQL Prompt is the "Copy as IN clause" feature. When you get the results back from running a query, you can highlight the entire column (or just the values you care about), then right-click and choose "Copy as IN clause." This will save those values to your clip board as an IN statement. So if you highlight values 1,2,3 it will put "IN (1,2,3)" onto your clipboard. This is handy during data exploration and feeding values from one query into another, such as grabbing the ID's from one query and dropping them onto the where clause of another query. / comments
Another handy one from SQL Prompt is the "Copy as IN clause" feature. When you get the results back from running a query, you can highlight the entire column (or just the values you care about), t...