8 Ways to Export SQL Results To a Text File

From SQL Server Wiki
Jump to navigation Jump to search
  1. Shows results to a file in SQL Server Management Studio (SSMS)
  2. SQLCMD
  3. PowerShell
  4. Import/Export Wizard in SSMS
  5. SSIS Wizard (almost the same than the number 4, but we are using SSDT instead of SSMS to create the package).
  6. C#
  7. SSRS
  8. BCP