数据导出到文本文本文件里。
字段 字段2
tt a
tt b
pp s
pp g
pp f
pp j
导出来的文本里的格式是：
tt a,b
pp s,g,f,j
[解决办法]
Create Table TEST
(AVarchar(10),
BVarchar(10))
Insert TEST Select 'tt ', 'a '
Union All Select 'tt ', 'b '
Union All Select 'pp ', 's '
Union All Select 'pp ', 'g '
Union All Select 'pp ', 'f '
Union All Select 'pp ', 'j '
GO
Create Function F_TEST(@AVarchar(10))
Returns Varchar(8000)
As
Begin
Declare @S Varchar(8000)
Select @S = ' '
Select @S= @S + ', ' + B From TEST Where A = @A
Select @S = Stuff(@S, 1, 1, ' ')
Return @S
End
GO
Declare @S Varchar(8000)
Set @S= 'bcp "Select A, TEST.dbo.F_TEST(A) As B from TEST.dbo.TEST Group By A " Queryout "D:\TEST.txt " -c -q -S "(local) " -U "sa " -P "sa " '
Exec master..xp_cmdshell @S
GO
Drop Table TEST
Drop Function F_TEST
