34,875
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
playyuer 2003-10-24
- 打赏
- 举报
--但相当于有登录连接一次!
playyuer 2003-10-24
- 打赏
- 举报
SELECT * into #T
FROM OPENROWSET('SQLOLEDB','ServerName';'sa';'','Exec p_name') AS a
--但相当于有登录一次!
FROM OPENROWSET('SQLOLEDB','ServerName';'sa';'','Exec p_name') AS a
--但相当于有登录一次!
gmlxf 2003-10-24
- 打赏
- 举报
create table #临时表
insert #临时表 Exec p_name
select * from #临时表
insert #临时表 Exec p_name
select * from #临时表
whaisheng 2003-10-24
- 打赏
- 举报
#insert #tablename exec name
txlicenhe 2003-10-24
- 打赏
- 举报
eg:
1: Create procedure test
As
Select 1 as id,'abc' as name
go
2:
Create table #tmp (a int,b varchar(10))
insert #tmp Exec test
Select * from #tmp
注意必须先建临时表，再用insert #tmp Exec test
1: Create procedure test
As
Select 1 as id,'abc' as name
go
2:
Create table #tmp (a int,b varchar(10))
insert #tmp Exec test
Select * from #tmp
注意必须先建临时表，再用insert #tmp Exec test
