情况一:全部字段都需要加字符,在这里设置【文本限定符】就可以了。
情况二:
--
某些特殊的字段需要加单引号(或者其它符号)
SELECT
[ ID ]
, '''' + convert ( varchar ( 25 ), [ ts ] , 121 ) + '''' as [ ts ]
, '''' + convert ( varchar ( 25 ), [ otherParty ] , 121 ) + '''' as [ otherParty ]
, '''' + convert ( varchar ( 25 ), [ StartTime ] , 121 ) + '''' as [ StartTime ]
, [ CcCause ]
, [ RrCause ]
FROM [ 表 ]
SELECT
[ ID ]
, '''' + convert ( varchar ( 25 ), [ ts ] , 121 ) + '''' as [ ts ]
, '''' + convert ( varchar ( 25 ), [ otherParty ] , 121 ) + '''' as [ otherParty ]
, '''' + convert ( varchar ( 25 ), [ StartTime ] , 121 ) + '''' as [ StartTime ]
, [ CcCause ]
, [ RrCause ]
FROM [ 表 ]
效果:74983006,'2010-03-09 23:59:10.000'