SQL Server的SQL技巧
- WBOY原創
- 2016-06-07 15:00:211065瀏覽
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
陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn