首页 新闻 会员 周边

c#调用游标输出的存储过程(sqlserver)

0
悬赏园豆：80 [待解决问题]

c#怎么调用？

create proc uspProc(
@level int,
@cur cursor varying output
)
as
begin
---
---
---
end
jhjs的主页 jhjs | 初学一级 | 园豆：11
提问于：2018-07-19 12:09
< >
分享
所有回答(1)
0

无法调用，详见微软官方文档 Return Data from a Stored Procedure：

The cursor data type cannot be bound to application variables through the database APIs such as OLE DB, ODBC, ADO, and DB-Library. Because OUTPUT parameters must be bound before an application can execute a procedure, procedures with cursor OUTPUT parameters cannot be called from the database APIs. These procedures can be called from Transact-SQL batches, procedures, or triggers only when the cursor OUTPUT variable is assigned to a Transact-SQL local cursor variable.

dudu | 园豆：30979 (高人七级) | 2018-07-19 13:51
清除回答草稿
   您需要登录以后才能回答，未注册用户请先注册。