排序存储的效果图:
根据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,\'^\',\',\')))
请发表评论