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
Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.
2021-04-13
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)
401,312 reads
2016-03-25 (first published: 2015-01-30)
2,417 reads
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,546 reads
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
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
With the following data, I need to create a column that will display a...
I have two attributes hierarchies in my dimension [Dim Project]: Project Code Opening date...
Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...