Export query result to .csv file in SQL Server 2008

by
  1. Open SQL Server Management Studio
  2. Go to Tools > Options > Query
    Results > SQL Server > Results To Text
  3. On the far right, there is a drop
    down box called Output Format
  4. Choose Comma Delimited and click OK

Here’s a full screen version of that image, below

enter image description here

This will show your query results as comma-delimited text.

To save the results of a query to a file: Ctrl + Shift + F

More Related Contents:

  1. How to connect to local instance of SQL Server 2008 Express
  2. T-SQL: Export to new Excel file
  3. Enable ‘xp_cmdshell’ SQL Server
  4. Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation
  5. SQL MERGE statement to update data
  6. How to get the last record per group in SQL
  7. A transport-level error has occurred when receiving results from the server [closed]
  8. storing passwords in SQL Server
  9. How does sql server sort your data?
  10. How to restore to a different database in SQL Server?
  11. Why is SQL Server 2008 Management Studio Intellisense not working?
  12. Reporting Services permissions on SQL Server R2 SSRS
  13. T-SQL substring – separating first and last name
  14. How to implement polymorphic associations in an existing database
  15. How to get week number of the month from the date in sql server 2008
  16. Optional parameters in SQL Server stored procedure
  17. Entity Framework Database.SetInitializer simply not working
  18. Cannot open backup device. Operating System error 5
  19. Restoring database from .mdf and .ldf files of SQL Server 2008
  20. What is the default transaction isolation level for SQL Server with ADO.NET?
  21. Restrict SQL Server Login access to only one database
  22. T-SQL strip all non-alpha and non-numeric characters
  23. How can I get a trigger to fire on each inserted row during an INSERT INTO Table (etc) SELECT * FROM Table2?
  24. Avoiding IF ELSE due to variable been NULL
  25. Where are SQL Server connection attempts logged?
  26. Can I pass variable to select statement as column name in SQL Server [duplicate]
  27. SQL Server 2008 Connection Error “No process is on the other end of the pipe”
  28. SSIS LookUp is not dealing with NULLs like the docs say it should
  29. Recursive Child/Parent queries in T/SQL
  30. Forcing code-first to always initialize a non-existent database?

Leave a Comment