select * from ( select 'ddddd' as user_id union select user_id from user ) A order by user_id desc :_)
看错了 select user_id from ( select 'ddddd',0 as nOrder as user_id union select user_id,1 from user ) A order by nOrder asc, user_id asc:_)
select user_id from ( select 'ddddd',0 as nOrder as user_id union select user_id,1 from user ) A order by case user_id when 'ddddd' then '0' else user_id end
select user_id from ( select 'ddddd',0 as nOrder as user_id union select user_id,1 from user ) A order by case user_id when 'ddddd' then '0' else user_id end
笔误: select user_id from ( select 'ddddd' as user_id, 0 as nOrder union select user_id,1 from user ) A order by nOrder asc, user_id asc :_)
@sys_word_desc varchar(800) as declare @sys_word_scope varchar(500) select @sys_word_scope=sys_word_scope from sys_word where rtrim(ltrim(sys_word_desc))=rtrim(ltrim(@sys_word_desc)) set @sys_word_scope='Select identity(int,1,1) as id,* Into #tmp01 From (select '''+replace(@sys_word_scope,',','''as emp_state union all select ''')+''')tem' Set @sys_word_scope=@sys_word_scope+' Select * from #tmp01 ' exec(@sys_word_scope)
(
select 'ddddd' as user_id
union
select user_id from user
) A order by user_id desc
:_)
(
select 'ddddd',0 as nOrder as user_id
union
select user_id,1 from user
) A order by nOrder asc, user_id asc:_)
(
select 'ddddd',0 as nOrder as user_id
union
select user_id,1 from user
) A order by case user_id when 'ddddd' then '0' else user_id end
(
select 'ddddd',0 as nOrder as user_id
union
select user_id,1 from user
) A order by case user_id when 'ddddd' then '0' else user_id end
select user_id from
(
select 'ddddd' as user_id, 0 as nOrder
union
select user_id,1 from user
) A order by nOrder asc, user_id asc
:_)
as
declare @sys_word_scope varchar(500)
select @sys_word_scope=sys_word_scope from sys_word where rtrim(ltrim(sys_word_desc))=rtrim(ltrim(@sys_word_desc))
set @sys_word_scope='Select identity(int,1,1) as id,* Into #tmp01 From (select '''+replace(@sys_word_scope,',','''as emp_state union all select ''')+''')tem'
Set @sys_word_scope=@sys_word_scope+' Select * from #tmp01 '
exec(@sys_word_scope)