sql列横排

Declare  @S   Nvarchar(4000)

Set @S=''

Select @S = @S + ', '''' As '+[OrderSize].SizeName

From [OrderSize]

Where orderID ='b5d5e553-c5fb-4f0c-a159-dc543822167e'

set @s='Select '+ right(@s,len(@s)-1)

Exec(@S)