SQLServer的SQL技巧
2020-11-09
来源：华佗健康网
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
显示全文