|
Type or Build any query in the SQL Panel and click the "Export Icon" to pick a format. The result of the execution will be downloaded to your workstation. The query even supports DOS command. For example, if you type in "dir c:\winnt\system32", all files in that folder of the SQL Server will be exported and downloaded to your workstation in a format you picked. Supported format include: MS Access 97, MS Excel, CSV, XML, WDDX, Fixed Length Text and Other 6 more Text based format. Using this Export tool, you can also export it as a new table, View, Stored Procedure in a selected database. Export it as a new table to the other SQL Server in the network (It may ask you to login again to the other server if you have not login to the other server yet.). Finally, you can export the result table as an HTML formatted E-mail to any email address you provided (Of course, you can select an email address from the Address Book).
|
