bcp
Bulk Load Files into SQL Azure?
I have an ASP.NET app that takes multimegabyte file uploads, writes them to disk, and later MSSQL 2008 loads them with BCP.[详细]
2023-03-13 13:20 分类:问答How do I find BCP on a SQL Server?
I am creating a library of code that will be deployed across several dozen Sql Servers in a corporate environment.Versions of SQL Server are mostly 2008, but some 2000, 2005 and 2008R2 instances exist[详细]
2023-03-13 13:03 分类:问答Struggling with SQL BCP (uniqidentifier, default values on columns...)
EDIT: My only pending issue is c) (True and False on file, bit on database, I can\'t change neither the file nor the database scheme, there\'s hundreds of terabytes I can\'t touch).[详细]
2023-03-08 08:02 分类:问答Bulk Copy from small table to larger one in SQL Server 2005
I\'m a newbie in SQL Server and have the following dilemma: I have two tables with the same structure. Call it runningTbl and finalTbl.[详细]
2023-03-07 14:49 分类:问答BCP export with a comma row delimiter
I currently have a sproc that is exporting data to a csv file using bcp.It currently works fine except due to a change of requirment the file no longer can have a \'\\n\' row delimiter and must now ha[详细]
2023-03-04 16:35 分类:问答Is it possible to load a subset of columns using Sybase 15 bcp?
I have a CSV file with 20 or so columns and I want to load it into a table with only 9 columns - I want to throw away the rest.[详细]
2023-03-03 05:50 分类:问答Is there a way to force truncated columns to be inserted into a SQL Server table?
Data are given to me in a spread sheet which I\'m converting to pipe-delimited files. I tried inserting over 46000 rows but four (4) of them failed with the error message[详细]
2023-03-01 01:12 分类:问答appending records using bcp into a csv or text file
how do I append records to an existing csv file on my C: drive by using BCP export of SQL Server. Name[详细]
2023-02-28 10:41 分类:问答import only new or updated records into sql database, using bcp to import and export
I am having a csv file. Now, i have to import all the data from this file into my sql database, mdf file.[详细]
2023-02-28 07:25 分类:问答bcp command not working
I\'m using the following bcp command BCP \"select * from PACIFIC.dbo.CEOExtractCorpRulesView with(nolock) \"[详细]
2023-02-18 20:54 分类:问答