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 60085

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

2
votes
I created a table value function (taken from here) to create an ordered split of your string. CREATE FUNCTION dbo.SplitStrings ( @List NVARCHAR(MAX), @Delimiter NVARCHAR(255) ) RETURNS …
answered May 17 '18 by Scott Hodgin
1
vote
Assuming Sql Server (and noticing that your data has double quotes), have a look at this post - Importing CSV with optional double quote text qualifier. It discusses two options for importing data using a FORMAT file. OPENROWSET and BULK INSERT …
answered Nov 3 '16 by Scott Hodgin
1
vote
Similar to @Randi's approach If using POWERSHELL is an option, you can change the job type to POWERSHELL and use INVOKE-SQLCMD. A possible downside to this approach is because ConvertTo-CSV … "." -Query "Select name from sys.databases where Database_ID <=4" | ConvertTo-Csv -NoTypeInformation | % {$_ -replace '"',''} | Select-Object -Skip 1 | Out-File ("C:\Test\test.txt") -Append -Force …
answered Dec 6 '18 by Scott Hodgin
3
votes
Powershell: $OutFile = "c:\test\testout.txt" Invoke-SqlCmd -Query "select * from test.dbo.billingdata" -ServerInstance . | ConvertTo-CSV -NoTypeInformation | Select-Object | % {$_ -replace …
answered Nov 13 by Scott Hodgin
2
votes
You should be able to use CROSS APPLY. In an effort to provide a Minimum Complete Verifiable Example, I've included a 'simple' SPLIT TVF which is intended to emulate your INTLIST_TO_TBL function. T …
answered Sep 12 '17 by Scott Hodgin
2
votes
I started by extracting the SELECT query into a separate SSMS window. I replaced double-ticks (quotes) with single-ticks and added into dbo.TableForEmailingLogBackups that would allow me to create a …
answered Sep 11 by Scott Hodgin
1
vote
This link has suggestions for dealing with double quotes while trying to import data using BULK INSERT and the BCP utility using a format file. This link has suggestions for dealing with double quote …
answered Sep 26 '16 by Scott Hodgin