Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options answers only user 30859

Questions on how to import into, extract data from, or exchange data between databases in CSV format (plain text using commas to separate values).

5
votes
My preferred approach to pass in multiple rows of multiple fields (i.e. not a simple delimited list) is to use Table-Valued Parameters (TVPs). The idea is that you will read the file line by line in y …
answered Jul 30 '16 by Solomon Rutzky
6
votes
There are some issues with this request: What version and edition of SQL Server is the target system? How much data is being imported? 10k, 10 Mb, more? How many CSV files are there? You have … will there also be embedded row delimiters (i.e. \r\n or just \n )? These are the biggest problem for most CSV parsers. In a comment on Scott's answer you raise a concern about: "Double quotes is one …
answered Sep 29 '16 by Solomon Rutzky
1
vote
You don't have to do this in pieces. You can do all of this inline, in a set-based approach, in batches (so that the size of the input file is irrelevant). Just think in terms of how you would take a …
answered Oct 24 '17 by Solomon Rutzky
7
votes
I, too, used to have problems exporting large result sets (7 - 8 GB) to delimited files. Neither SQLCMD nor BCP nor SSIS could handle dynamic result sets, dynamic text-qualification, adding a column h …
answered Oct 4 '17 by Solomon Rutzky