SQL query with actxserver
显示 更早的评论
I am trying to run a SQL stored procedure that returns a parameter but I can't figure out how to get that value. When I run this psuedo code I get an error saying I need to define the output parameter. I know the DB connection is correct and works because I have other stored procedures that work but none of them have output.
DB = actxserver('ADODB.Connection') DB.Open( serverstuff here) DB.Execute('exec procedurename @inputParam=string')
回答（1 个）
Madhura Suresh
2014-1-31
0 个投票
Have you tried using fetch?
a= DB.exec(query) data=fetch(a)
2 个评论
Reese
2014-1-31
Madhura Suresh
2014-2-5
What version of MATLAB are you using? SQL queries might work, but there is no workaround for stored procedures using ACTXSERVER.
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
2014-2-5
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
