Posted: 2/22/2005 12:00:21 PM EDT
|
Up until now, I've only used oracle sql. A new databse I need to use here at work is running microsoft sql server. Are there any better tools than the "microsoft sql query analyzer" for running queries against the databse? This thing kind of sucks. It seems excessivly difficult to get the results of a query into excel along with the column headings. The tool I use for running queries on our oracle database is pretty nice ... you can just right click in the data area and hit "export to excel" and it will launch excel, and send your results table there along with the column headings. |
www.toadsoft.com/ Enterprise Manager is fairly good. I dont run a lot of MSSQL stuff personally...atleast not without drawing it from applications. I will ask some friends of mine and PM you if I find anything better for you to use. edited - link |
It's actually pretty easy to do what you're wanting to do. Open SQL Enterprise Manager, drill down to the database you want the information out of, right click it, select All Tasks and select Export Data, the DTS Import/Export Wizard will pop up. Click next on the opening screen, accept the default data source on the second screen, on the next screen select Microsoft Excel 97-2000 in the drop down menu under destination, give it a file name, click next on that screen, on the next screen choose the option "Use a query to to specify the data to transfer", click next, type in your query on the next screen, click next on the next screen, make sure the "Run Immediately" button is checked, click next, then click Finish. Your file will have all header information and will be in perfect Excel format. IM me if you need more help. |
ugh ... I guess that's what I'll do. Thanks. In the program I use now, I right click in the data area and hit export to excel and it's done. It doesn't export to an excel file ... it launches excel and places your data into a worksheet, ready to use.  |
I didn't say it was better than what you had; I was just saying that it could be done. |
yep, wasn't ragging on you, just whining about change who moved my fuckin cheese |