SQL output Custom Delimiter

Question

How do I create my SQL output like the following. (with , delimiter)

"1","FUZION",""

http://postimg.org/image/xehmnq5g5/

are you looking for csv output? http://stackoverflow.com/questions/16079666/how-to-produce-an-csv-output-file-from-stored-procedure-in-sql-server — NSjonas, Jan 15 '14 at 05:39

score 0 · Answer 1 · answered Jan 15 '14 at 06:23

0

Assuming that you are selecting data from 3 columns -

col1 = '1'
col2 = 'Fuzion'
col3 = ''

All 3 fields being VARCHAR & you are using SQL SERVER.

You could try something like this -

SELECT '"'+ISNULL(col1,'')+'","'+ISNULL(col2,'')+'","'+ISNULL(col3,'')+'"'

Note - If any of your field is not a VARCHAR - cast it to VARCHAR and then concatenate.

answered Jan 15 '14 at 06:23

Suyash Khandwe

386
3
11

by using -s "," in SQLCMD, my output result like the following 1,FUZION. All i want is "1","FUZION". Thanks – alexcctan Jan 16 '14 at 04:38
However, I managed to get it done by the following query Select MerchantID = +'"' + Convert(varchar(20),microsdb.CHECKS.RevCtrID) + '"', DeviceSN = +'"' + Convert(varchar(20),microsdb.CHECKS.LastWorkstationID) + '"', Many Thanks guys for the reference – alexcctan Jan 16 '14 at 08:20

score 0 · Accepted Answer · answered Jan 15 '14 at 07:14

Refer to the below script.

DECLARE @MyOrderList VARCHAR(MAX);
SET @MyOrderList = ''
SELECT @MyOrderList = ISNULL(@MyOrderList ,'') +  '"' +ColumnName + '" ,' FROM TableName

SET @MyOrderList = SUBSTRING(@MyOrderList , 1, LEN(@MyOrderList )-1)
SELECT @MyOrderList

Hope this solves your problem.

SQL output Custom Delimiter

2 Answers2