首页 新闻 赞助 找找看

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 | 园豆:31324 (高人七级) | 2018-07-19 13:51
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册