在桌子顶部插入行

Question

我有这个表

select 
    Store_Desc + ' ('+Store_ID + ')' as storename  
from  
    table_name  
order by
    ID

结果：

 Apple (0051)
 Cherries (0060)
 Banana (0081)

在结果的顶部，我需要另一行看起来像：

结果：

Fruits
----------------
Apple (0051)
Cherries (0060)
Banana (0081)

我应该如何插入上排，以降低订单(如果需要时我可以使用临时表(

Answer 1

，除非您使用临时表需要重复ID

select Store_Desc + ' (' + Store_ID +')' as storename, ID  
from table_name  
union all 
select 'fruit', '0'
order BY  ID  

或

declare @T table (storename varchar(20), ID varchar(10));
insert into @T values ('fruit', '0');
insert into @T 
select select Store_Desc + ' (' + Store_ID + ')', ID  
from  table_name;
select storename 
from @T 
order by ID;