--转换字符再导出就行了.
exec master..xp_cmdshell 'bcp "select name,right(space(38)+cast(val as varchar),38) from 数据库名..表名" queryout c:\tmp.txt /P"" /c'
exec master..xp_cmdshell 'bcp "select name,right(space(38)+cast(val as varchar),38) from 数据库名..表名" queryout c:\tmp.txt /P"" /c'
insert into ##T
select 'a',100
union all select 'b',2exec master..xp_cmdshell 'bcp "select name,right(space(38)+cast(val as varchar),38) from ##t" queryout c:\tmp.txt /P"" /c'drop table ##t