Exporting Data

8 Ways to Export SQL Results To a Text File

This tip will show eight ways to export the results of a query to a text file.

SQLCMD to export data in txt file

SQLCMD is one of many methods to export your database data to some text file

SQLCMD and Batch File magic

Execute scripts in a folder with a single click using SQLCMD and a batch file.

SQLCMD connection switching

SQLCMD Mode; Run all SQL files in a directory

SQLCMD Mode gives you the ability to access command line executables via SSMS. Using creative approach, you can automate the execution of all files within a specified directory.

Mail Fails with SQLCMD Error

I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.

SQL Server SQLCMD Basics

Sqlcmd makes many SQL Server tasks, such as automating test runs and maintenance tasks, easier and quicker. The sqlcmd command-line utility is valuable to any database developer or DBA as the prime means of executing batches of SQL Statements to SQL servers, and saving results to file. Rob Sheldon gives you the basic facts about this great utility.

SQLCMD

An Introduction to the SQLCMD Mode in SSMS (SQL Spackle)

Using SQLCMD Mode in SSMS is easy. This short piece will show you how to get started.