Export SQL Server Data to Excel and Add New Columns with C#
Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.
2021-04-13
Export
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.
2017-10-06 (first published: 2016-10-26)
500,262 reads
2016-03-25 (first published: 2015-01-30)
2,696 reads
Export/import relational data across SQL Servers
The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server keeping the relational integrity intact, even when new primary keys are generated.
2009-07-08 (first published: 2009-06-22)
1,570 reads
Simple way to export SQL Server data to Text Files
With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.
2008-12-05
9,878 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers