I want to call other stored procedures in my stored procedure.
However, when I tried to call a stored procedure which return a result set rather than a single record, I don't know how to catch it in my stored procedures?
Are there some methods to catch up a result set returned by a stored procedure in another stored procedure?
Thanks!
Thomasinsert the resultset of the stored procedure into a table
create table
#tbl(spid int
, ecid int
, status varchar(15)
, loginame varchar(20)
, hostname varchar(15)
, blk int
, dbname varchar(15)
, cmd varchar(25))
insert into #tbl exec sp_who
select * From #tbl
No comments:
Post a Comment