SQLServer的SQL技巧

declare @tmpt table(a int,b numeric(20,3),c numeric(20,3)) insert into @tmpt EXECUTE cbdbfxt 2005,5,'670,' select * from @tmpt drop table #tmpt create table #tmpt(a int,b numeric(20,3),c numeric(20,3)); insert into #tmpt EXECUTE cbdbfxt 20

declare @tmpt table(a int,b numeric(20,3),c numeric(20,3))
insert into @tmpt EXECUTE cbdbfxt 2005,5,'670,'
select * from @tmpt

drop table #tmpt
create table #tmpt(a int,b numeric(20,3),c numeric(20,3));
insert into #tmpt EXECUTE cbdbfxt 2005,5,'670,'
select a,b from #tmpt

declare @ss varchar(100)
set @ss='select UserID from T_User'
create table #e(U varchar(10))
insert into #e exec(@ss)
select * from #e