MSSQL 2005导出某列

eg:

declare @sql nvarchar(4000)
set @sql='bcp "Select name from SemanticProject..concept" queryout "c:\DT.txt" -T -c'
--select @sql
EXEC master..xp_cmdshell @sql
Go