34,590
社区成员
发帖
与我相关
我的任务
分享
create proc sp_getdata
as
select 'AAAAA'
go
-- 把结果写到临时表
declare @t table( name varchar(30))
insert into @t exec sp_getdata
select * from @t
go
drop proc sp_getdata
go
(1 行受影响)
name
------------------------------
AAAAA
(1 行受影响)
CREATE PROCEDURE sp_test(@i int )
AS
BEGIN
SELECT @i
END
DECLARE @k INT
SELECT @k=i FROM OPENROWSET('SQLNCLI', 'server=(local);trusted_connection=yes', 'EXEC sp_test 10 WITH RESULT SETS ((i int))')
PRINT @k
/* 10 */