Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag BCP Rss

Search for any content tagged bcp

   Items 1 to 7 of 7   

Solving a Problem Importing Integers Using Format Files

When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.  Read more...
By Banyardi Schmardi 2012/02/16 | Source: | Category: bcp
Rating: |  Discuss |   Briefcase | 3,843 reads

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

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.  Read more...
By Bret Lowery 2011/07/18 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 9,616 reads

Easy Error Trapping When Using xp_cmdshell

Getting errors and output messages when using xp_cmdshell can be tricky. This method can solve your problems.  Read more...
By Sylvia Moestl Vasilik 2010/02/02 | Source: | Category: error handling
Rating: |  Discuss |   Briefcase | 7,592 reads

Importing and exporting bulk data with the bcp utility

The SQL Server bcp utility can help administrators easily import or export bulk data between text files and SQL Server tables.   Read more...
By Additional Articles 2009/03/04 | Source: SearchSQLServer | Category: bulk import
Rating:  Rate this |   Briefcase | 3,503 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.  Read more...
By Additional Articles 2008/12/05 | Source: | Category: export
Rating:  Rate this |   Briefcase | 9,344 reads

Binary Files Import and Export

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.  Read more...
By Sergey Benner 2008/08/28 | Source: | Category: bcp
Rating: |  Discuss |   Briefcase | 9,009 reads

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

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.  Read more...
By Solomon Rutzky 2008/06/24 | Source: | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 5,147 reads
   Items 1 to 7 of 7