union 是表之前联合,如果有重复的数据,不会排除重复数据
union all 表之前联合,如果有重复数据,会排除重复数据 两者要求,select语句必需拥有相同的列,每列的数据类型相同;而且每条select语句的列的顺序必需相同
CREATE PROCEDURE dbo.spappBarChartDemo
SELECT '下雨量' as sCategory,'1月份'as sLengedData,20.0 as Yvalue
into #temp //将给定的数据插入一个临时表
union all
SELECT '下雨量' as sCategory,'1月份'as sLengedData,30.0 as Yvalue
union all
SELECT '下雨量' as sCategory,'1月份'as sLengedData,20.0 as Yvalue
union all
SELECT '下雨量' as sCategory,'1月份'as sLengedData,50.0 as Yvalue
union all
SELECT '下雪量' as sCategory,'1月份'as sLengedData,30.0 as Yvalue
union all
SELECT '下雪量' as sCategory,'1月份'as sLengedData,40.0 as Yvalue
union all
SELECT '下雪量' as sCategory,'1月份'as sLengedData,20.0 as Yvalue
union all
SELECT '下雪量' as sCategory,'1月份'as sLengedData,50.0 as Yvalue
ORDER BY 1,2,3 //安装 sCategory sLengedData Yvalue的顺序排列
查看表中的数据 select * from #temp