bcp
SQL Server: BCP vs SQLCMD - what is more efficient?
I\'m writing a program in c# to export SQL Server data from one database and importing it in another. Since these two servers are not connected I need to choose a method such as bcp.[详细]
2023-01-21 16:37 分类:问答When SQL Server bcps into an empty table with an index what does it do internally?
If I have an empty table with an index and I do a bcp, does SQL Server (internally) drop/disa开发者_如何学运维ble the index, load the data and then re-apply/enable/build the index?No, the indexes are[详细]
2023-01-17 22:27 分类:问答Whats wrong with this bcp utility?
I am trying to export data into into a text file using bcp utility? I could n\'t figure out what i am doing wrong here:-[详细]
2023-01-17 03:40 分类:问答Getting a buildable Boost extract with bcp
I\'m using b开发者_高级运维cp to extract Boost.Archive from Boost. Unfortunately I can\'t build this extract. Boost.Archive is not a header-only library.[详细]
2023-01-14 10:03 分类:问答Way to create a table from a flat file in SQL Server without knowing datatypes?
Is there a way to load a flat file into SQL Server as a new table without knowing the data types of the columns in the file?[详细]
2023-01-12 19:56 分类:问答Help me use powershell and bcp to load CSV into SQL Server
I\'m using bcp to load a table from a CSV exported from another table by someone else far far away, and have run into some issues. My original two problems: one exported field is an int that needs to[详细]
2023-01-12 02:56 分类:问答BCP utility to create a format file, to import Excel data to SQL Server 2008 for BULK insertion
Am trying to import Excel 2003 data into SQL table for SQL Server 200开发者_运维问答8. Tried to add a linked server but have met with little success.[详细]
2023-01-11 05:16 分类:问答How to specify row separators when importing into an sqlite db from a csv with non-default field and row separators?
I have a bunch of data that i exported from mssql using bcp with custom field and row se开发者_如何学运维parators.I would like to import the data into an sqlite database..Is there an easy way to do th[详细]
2023-01-10 17:24 分类:问答What will be BCP format for inserting a identity column
I am facing problem while I am trying to insert data to a table using BCP. The table has a identity column. I am taking input from a text file. Please let me know if there are any good开发者_StackOver[详细]
2023-01-06 04:30 分类:问答Are there wildcards for BCP?
I\'m trying to run a command script that executes a BCP utility. I want it to be able to find any files with a specific file name format, for example, f开发者_开发问答ileyyyymmdd.dat.Is there any way[详细]
2023-01-05 18:37 分类:问答