Save query results on SQL Manager Lite


I´m using SQL Manager 2008 Lite and it shows the query results in a grid.
How do I save this grid or copy it to ClipBoard?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nguyen Huu PhuocSenior ManagerCommented:
Which grid do you use here?
You can iterate through over the grid and read the content of cells by cells and save value of cells to a strings which has your own format. After that you save this string to clipboard.When you read string from clipboard you parse it using your format and populate again the grid.
Hop it help you.
danival_lucasAuthor Commented:
No, I'm not building an application, I'm using SQL Manager 2008 Lite to access the database.
And using "SQL Editor" to run a query.
The query results appear on the grid below.
I need to know how to export these results to a file, or copy it to ClipBoard.

but anyway thanks for your reply.
Nguyen Huu PhuocSenior ManagerCommented:
Oh now I understand what you want.
I cannot help you.
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Refer to this to see what is possible and what is not in Lite:

EMS SQL Manager for SQL Server

It contains links of features for various versions. Particularly search for "paste cell".
Mark WillsTopic AdvisorCommented:
Is this a once-off task or a recurring job ?

I am not overly familiar with the EMS products, but could always download the "free" / "lite" version if needed.

There is also the SQL Server Management Studio (SSMS) for Express which is also free and you can simply select, copy and paste from that. Most of these tools however do have one small problem that they do not contain the column headers unless you output as a text / report type file. Fine if there are only a few columns, not so great if there are lots...

For "ongoing" exports, normally create some SQL script and use one of the MS SQL utilities such as BCP to create the output file. If "Lite" does allow you to type in your own T-SQL code, then the BCP utility might also be worth considering.

There is also the export tools from EMS - but might not be part of the "free" version. You might also need to create your query as a procedure, or maybe a view to simplify the export process.

If you can describe a bit more about your query and output requirement, we can probably suggest a few other things.
Steve BinkCommented:
I use EMS' MySQL products, and IIRC, the feature you want is not included in the free/trial version.

I recommend mark_wills suggestion - SSMS.  It does have the feature you want, is free, and is designed by the same people who created MSSQL.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
danival_lucasAuthor Commented:
I'm not using MS SQL Server.
I'm working with firebird.
I've posted on the firebird zone but no one answered the question there so the moderator put it on other zones.
But anyway thank you guys for your attention.
So the free version doesn't have this feature... I'll try another free tool.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.