SQLServerCentral.com Articles tagged BCP

Solving a Problem Importing Integers Using Format Files

Thu, 16 Feb 2012 07:00:00 UT

When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server

Mon, 18 Jul 2011 06:00:00 UT

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.

Easy Error Trapping When Using xp_cmdshell

Tue, 02 Feb 2010 07:00:00 UT

Getting errors and output messages when using xp_cmdshell can be tricky. This method can solve your problems.

Importing and exporting bulk data with the bcp utility

Wed, 04 Mar 2009 07:00:00 UT

The SQL Server bcp utility can help administrators easily import or export bulk data between text files and SQL Server tables.

Simple way to export SQL Server data to Text Files

Fri, 05 Dec 2008 07:00:00 UT

With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.

Binary Files Import and Export

Thu, 28 Aug 2008 06:00:00 UT

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.

Exporting and Versioning Lookup Data: A Real-World Use of the CLR

Tue, 24 Jun 2008 06:00:00 UT

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.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.