CREATE proc YongYouYongDianChaXun
@year varchar(4)
as
create table #t1(与存储过程的返回结果相同的表结构)
create table #t2(与存储过程的返回结果相同的表结构)insert into #t1 exec YouDianChildChaXun @year,'NR')
insert into #t2 exec YouDianChildChaXun @year,'DL')
select * from #t1
union
select * from #t2
go
@year varchar(4)
as
create table #t1(与存储过程的返回结果相同的表结构)
create table #t2(与存储过程的返回结果相同的表结构)insert into #t1 exec YouDianChildChaXun @year,'NR')
insert into #t2 exec YouDianChildChaXun @year,'DL')
select * from #t1
union
select * from #t2
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货