The bulk copy program `bcp` is a command line tool that can be used to export data from Microsoft® SQL Server™ or SAP Sybase Adaptive Server Enterprise databases to a data file in a user-specified format.
How can I specify an input sql file with a long query when using bcp? I tried using the -i …
sql sql-server sql-server-2008 bcpI use simple code declare @sql varchar(8000) select @sql = 'bcp ExcelAnalysis.dbo.ClearDB out c:\csv\comm.txt -c -t, …
sql-server csv bcpI'm sorry if this question has been asked already, but I couldn't find it anywhere. I have a table that …
sql-server sql-server-2005 tsql blob bcpRunning this: bcp MyDb.dbo.uvwMyView out "c:\Test.txt" -SMyServer -T -c I get this error: SQLState = S1000, NativeError = 0 …
sql-server bcpI need to export a fairly large SQL Server table ~100GB to a CSV file. But rather than the output …
sql sql-server database hive bcpI've been trying to work on taking the result of a large and multiply-joined SELECT statement, and email the query …
sql sql-server-2008-r2 bcp xp-cmdshellI have a very large csv file with ~500 columns, ~350k rows, which I am trying to import into an existing …
sql sql-server csv bulkinsert bcpI have been trying to import data (tab delimited) into SQL server. The source data is exported from IBM Cognos. …
sql sql-server bulkinsert bcp tab-delimitedI have a .CSV file that I created using SQL Server's BCP command-line BULK-COPY utility to dump a bunch of …
sql-server powershell bcpI have an ASP.NET app that takes multimegabyte file uploads, writes them to disk, and later MSSQL 2008 loads them …
azure bulkinsert azure-sql-database bcp