DB Toolbox: Calling Store Procedure
3 ビュー (過去 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!