FR: Export Table Data

Currently Table Export exports the entire set. It would be great to have a window where you could enter what you want after a From clause. this would allow you to filter down the result and possibly order by.

Also allow a Top number so you can limit the result set.

You would by default have Select Top 100 Percent * From Table

I could then enter:

Where Column2 = 'A'
Order by Column1

And you could then filter the data of the output.

To achieve that result, you can write any valid SQL query returning the required results, top, group, joins, order by, anything here, then execute it using SQL Assistant (CTRL+SHIFT+F9) instead of your editor's native code execution key, the right click the result grid and choose Save As... Select output file and format. That's it.

Hope that works for you.

That doesn't script it as insert statements.

I had a snippet that did that to a selected query but I haven't used it for long and I cannot find it. I can dig through my archives this week if it isn't urgent.

Thanks. Want to post it to the snippets repository?

Sure, provided I can find it...

I'm very sorry, haven't found it. I remember having it on Alt+2 but I haven't used it frequently and replaced it with something else (not using that on frequently either :( ).
I tried to rewrite it from scratch using some other snippets. It's far from being perfect but a good point to start from in case you're willing to improve it. I guess it doesn't handle special types like varbinary very well. As with all the other snippets I created, it is meant for SQL Server.