今天和梁翁在群里聊天小家伙突然抛出个有意思问题那就是串字段内串排序问题比如有列col,有数据'RDGS' ,要求输出为'DGRS'

当时我本想和梁翁讨论种思路那山羊闹着要聊天不许讨论技术问题所以这夜深时俺整理下和大家分享

-----------------------------------------------------------------------

-- Author: happyflystone

-- Date : 2009-01-17 22:56:11

-- Ver: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)

-- Apr 14 2006 01:12:25

-- Copyright (c) 1988-2005 Microsoft Corporation

-- Standard Edition _disibledevent=A.col

ORDER BY v

FOR XML PATH('')

),' ','')

FROM @t AS A