摘要：
排序存储的效果图：按ID排序的SQL存储过程：DECLARE@typevarchar (5000) select@type=sortable_textfromSortablewith（nolock）where sortable_type='NoteType'and[key]='00000000'select*from Notewith（nollock）where[key]='000000000'OrderB
排序存储的效果图：
根据id排序的sql存储过程：
DECLARE @type varchar(5000) select @type=sortable_text from Sortable with(nolock) where sortable_type='NoteType' and [key]='00000000' select * from Note with(nolock) where [key]='00000000' Order By charindex(','+ convert(varchar,id) +',', (SELECT REPLACE(@type,'^',',')))