DB Toolbox: Calling Store Procedure
1 次查看(过去 30 天)
显示 更早的评论
Hi,
I am using the Database toolbox to execute the store procedure.
tSQL = ['{call LiveCAT.dbo.[nameOfSP]('input1','input2')}'];
execute( connDB, tSQL)
info = fetch(connDB, ' SELECT * FROM #Results')
or
curs = exec( conn, tSQL);
dbList= fetch( curs);
I didn't get any return result. I think it didn't work because there're interim SQL statement in between before final SELECT query. Please provide suggestion.
The SP looks like this
ALTER PROCEDURE [dbo].[nameOfSP] (@peril varchar(255), @name varchar(255))
AS
BEGIN
create table #Results
(Exposure_BaseId bigint null, Company varchar(400))
INSERT INTO #Results(Exposure_BaseId, Company )
Exec(@myQuery)
Select distinct Exposure_BaseId,Company ,
from #Results
END
0 个评论
回答(1 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!