2009-12-23
2,780 reads
2009-12-23
2,780 reads
2009-11-03 (first published: 2009-10-06)
1,929 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,539 reads
The SQL Server bcp utility can help administrators easily import or export bulk data between text files and SQL Server tables.
2009-03-04
4,119 reads
Using opendatasource to retrieve data from Excel files as if querying a table.
2011-03-22 (first published: 2009-01-27)
11,596 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
2008-10-22
1,247 reads
Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.
2018-01-12 (first published: 2008-08-28)
20,315 reads
The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.
2008-06-24
5,398 reads
I thought that it would return other then null as well. After I got the 'you are incorrect' message I copied the SQL directly from the html page and pasted it into DB Artisan running against my local SQL Server installation. To my surprise, I was right. I did get a return like answer c. […]
2005-05-16
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers