Atlanta Custom Software Development 

 
   Search        Code/Page
 

User Login
Email

Password

 

Forgot the Password?
Services
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
Programming
VB VB (1648)
VB.net VB.net (736)
C# C# (15)
ASP.net ASP.net (779)
ASP ASP (41)
VC++ VC++ (25)
PHP PHP (0)
JAVA JAVA (4)
JScript JScript (5)
  Database
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
Automation
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
OS/Networking
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
Graphics
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
Links
» ASP.net (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» VB.net (4)
» VC (3)
» HTML/CSS/JavaScript (10)
Tools
» Regular Expr Tester
» Free Tools

 

How to export table or Query output to a file using BCP
Total Hit (2214) To export Query result to a file use following command to your command prompt «code LangId=6»EXEC master..xp_cmdshell 'bcp "select * from pubs..authors" queryout c:\authors.txt -c -Usa -Pmypassword'«/code» To export table to a file use following command to your command prompt «code LangId ....Read More
Rating
Error=[Microsoft ][odbc sql server driver] I/O error while reading BCP file format
Total Hit (5818) I was getting the follwoing error when used BCP format file. <font color=red>sql state s1000, native error=0 Error=[Microsoft ][odbc sql server driver] I/O error while reading BCP file format</font> I was sure that I used a correct BCP file format as shown below. I used a format file sh ....Read More
Rating
Export table/query to CSV, XLS or TXT format with column headers and custom row/field terminators
Total Hit (2866) If you never used BCP then I think you have not taken it seriously. BCP gives you non-logged functionality which is tremendously faster than logged operations. Many times we have requirements to export data from SQL server to disk file which can be CSV, XLS or text format. Generally people write pro ....Read More
Rating
How to create Format File using BCP command
Total Hit (16136) When you bulk import into a SQL Server table or bulk export data from a table, you can use a format file to store format information for each field in a data file relative to that table. A format file provides a flexible system for writing data files that requires little or no editing to comply with ....Read More
Rating
This is a link to a different site Understanding BCP/BULK COPY Format Files
Total Hit (927) In Microsoft SQL Server 2000 and earlier, bulk exporting and importing works with a single type of format file. This is supported in Microsoft SQL Server 2005. SQL Server 2005 also supports XML format files as an alternative. To distinguish format files of the original type, they are called non-XML ....Read More
Rating
This is a link to a different site Importing and Exporting Data with SQL Server
Total Hit (997) Transferring data, whether into or out of a database, can be a complex process. SQL Server provides several tools that help you in a variety of situations, including the Bulk Copy Program, the Select statement, the Transfer Manager, and Query results. This chapter examines those options, and times w ....Read More
Rating


Recommanded Links

 

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.