USE tempdb GODECLARE @PhysicalPath NVARCHAR(256),@Sql NVARCHAR(MAX)SET @PhysicalPath='H:\aa.txt'DECLARE @tmp TABLE (ID INT IDENTITY(1,1) PRIMARY KEY,Val NVARCHAR(50))INSERT INTO @tmp (Val) SELECT N'Out' UNION ALL SELECT N'Query Result' UNION ALL SELECT N'Into' UNION ALL SELECT N'Txt File.'
SELECT @Sql=ISNULL(@Sql+' ','')+Val FROM @tmp SET @Sql='Exec master.sys.xp_cmdshell ''echo '+@Sql+' >> '+@PhysicalPath+' '',no_output'EXEC (@Sql)
select Stu_Name+',' from T_Student FOR XML PATH('')
输出格式xiaoma,xiaoma,xiaowang,xiaozheng,xiaozheng,xiaohong,xiaoming,参考链接http://www.cnblogs.com/yanghaibo/archive/2010/06/04/1751405.html
select (select Stu_Name+',' from T_Student where Stu_Name='xiaoma' FOR XML PATH('')) as TextValue
输出TextValue
xiaoma,xiaoma,
--------------------------------------------------
pdf1/dxj_2005_001/14/06/111.pdf
pdf1/dxj_2005_001/14/06/112.pdf
pdf1/dxj_2005_001/14/06/113.pdf(3 行受影响)
GODECLARE @PhysicalPath NVARCHAR(256),@Sql NVARCHAR(MAX)SET @PhysicalPath='H:\aa.txt'DECLARE @tmp TABLE (ID INT IDENTITY(1,1) PRIMARY KEY,Val NVARCHAR(50))INSERT INTO @tmp (Val)
SELECT N'Out' UNION ALL
SELECT N'Query Result' UNION ALL
SELECT N'Into' UNION ALL
SELECT N'Txt File.'
SELECT @Sql=ISNULL(@Sql+' ','')+Val FROM @tmp
SET @Sql='Exec master.sys.xp_cmdshell ''echo '+@Sql+' >> '+@PhysicalPath+' '',no_output'EXEC (@Sql)