例如数据 列Name
name a b c d
a*b*c*d*declare @test table( namevarchar(10)) insert into @testvalues('a'),('b'),('c'),('d'); select distinct (select cast(name asvarchar(2))+'*'from @test for xml path(''))as name from @test
(4 row(s) affected) name -------------------------------------------------- a*b*c*d* (1 row(s) affected)