File Transfer

Question No. 1:-  How to change SQL Queries result to Text File and ExcelFile. and vice-versa. ?
Question No. 2:- how to change  SQL Queries result to XML and  vice-versa. ?
Varun GaurAsked:
Who is Participating?
 
Mark WillsTopic AdvisorCommented:
This is a huge question because there are so many different ways to achieve your results.

The XML can be/is a bit more involved....

A lot will depend on how experienced / comfortable you are with T-SQL

But as a starting guide :

1) Copy results to output in SSMS : https://docs.microsoft.com/en-us/sql/ssms/visual-db-tools/copy-query-results-visual-database-tools
2) using import/export wizard  https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/import-and-export-data-with-the-sql-server-import-and-export-wizard
3) rowset functions : https://docs.microsoft.com/en-us/sql/t-sql/functions/rowset-functions-transact-sql
4) BCP utility : https://docs.microsoft.com/en-us/sql/t-sql/functions/rowset-functions-transact-sql
5) Sqlcmd utility : https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility
6) LinkedServers : https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine
7) XML Data : https://docs.microsoft.com/en-us/sql/relational-databases/xml/xml-data-sql-server

And more...  Including following all the links in the above. It is a big topic.

And, when you become more proficient with T-SQL, then you start to "roll-your-own" solutions with code.

Google can be your best friend in this type on investigation / learning curve.

I would suggest you read and take notes, follow example etc. The rise a question on a topic where you need help to understand / clarify / get errors.

Cheers,
Mark Wills
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.