大白鲨博客

欢迎讨论.Net技术、delphi技术、C++等技术(我的QQ号:353079102)

导航

SQL Server的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 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

posted on 2007-06-18 08:45  大白鲨  阅读(311)  评论(0编辑  收藏  举报