<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Articles with tag
BCP
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:
SQLServerCentral.com
|
Category:
bcp
Rating:
|
Discuss
|
Briefcase
|
3,784 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:
SQLServerCentral.com
|
Category:
sqlclr
Rating:
|
Discuss
|
Briefcase
|
6,430 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:
SQLServerCentral.com
|
Category:
error handling
Rating:
|
Discuss
|
Briefcase
|
6,839 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,046 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:
MSSQLTips.com
|
Category:
export
Rating:
Rate this
|
Briefcase
|
8,489 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:
SQLServerCentral.com
|
Category:
bcp
Rating:
|
Discuss
|
Briefcase
|
8,676 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:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
5,071 reads
Items 1 to 7 of 7
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
