I have an ASP.NET app that takes multimegabyte file uploads, writes them to disk, and later MSSQL 2008 loads them with BCP.
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
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).
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.
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
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.
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
how do I append records to an existing csv file on my C: drive by using BCP export of SQL Server. Name
I am having a csv file. Now, i have to import all the data from this file into my sql database, mdf file.
I\'m using the following bcp command BCP \"select * from PACIFIC.dbo.CEOExtractCorpRulesView with(nolock) \"
加载中,请稍侯......