Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?

by

In SSMS, “Query” menu item… “Results to”… “Results to File”

Shortcut = CTRL+shift+F

You can set it globally too

“Tools”… “Options”… “Query Results”… “SQL Server”.. “Default destination” drop down

Edit: after comment

In SSMS, “Query” menu item… “SQLCMD” mode

This allows you to run “command line” like actions.

A quick test in my SSMS 2008

:OUT c:\foo.txt
SELECT * FROM sys.objects

Edit, Sep 2012

:OUT c:\foo.txt
SET NOCOUNT ON;SELECT * FROM sys.objects

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. CROSS JOIN vs INNER JOIN in SQL
  3. How to cast the DateTime to Time
  4. How can I schedule a job to run a SQL query daily?
  5. How to generate a range of numbers between two numbers?
  6. Reset identity seed after deleting records in SQL Server
  7. How to avoid the “divide by zero” error in SQL?
  8. Multiple INSERT statements vs. single INSERT with multiple VALUES
  9. Real life example, when to use OUTER / CROSS APPLY in SQL
  10. How to update Identity Column in SQL Server?
  11. Common Table Expression, why semicolon?
  12. T-SQL split string based on delimiter
  13. Concatenate values based on ID
  14. SQL Server 2008: how do I grant privileges to a username?
  15. How do I find duplicates across multiple columns?
  16. Detect consecutive dates ranges using SQL
  17. Split values over multiple rows [duplicate]
  18. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  19. How to do an inner join on row number in sql server
  20. Execute Dynamic Query with go in sql
  21. TransactSQL to run another TransactSQL script
  22. How can I get a list of element names from an XML value in SQL Server
  23. Stored procedure that exports data into csv files only exports to one file
  24. SQL Server: should I use information_schema tables over sys tables?
  25. How to rename something in SQL Server that has square brackets in the name?
  26. how to separate string into different columns?
  27. TSQL – How to use GO inside of a BEGIN .. END block?
  28. SQL take just the numeric values from a varchar
  29. How to execute a stored procedure inside a select query
  30. Using CASE Statement inside IN Clause

Leave a Comment