)
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,
‘^‘,
‘,‘)))
c#排序sql语句查询
标签:sql存储过程 图片 效果 src char inf bsp png where