我如何调用过程具有CURSOR VARYING OUTPUT [英] how i can call procedure has CURSOR VARYING OUTPUT

问题描述

大家好
我在sql server数据库中有此过程

hi every one
i have this procedure in sql server database

PROCEDURE  [dbo].[get_user_pern]
(@p_user nvarchar(200)  , @p_pass nvarchar(50)  , @permissionCursor CURSOR VARYING OUTPUT)
AS
SET @permissionCursor = CURSOR
FORWARD_ONLY STATIC FOR
      SELECT *
      FROM users_hor
 where user_names=@p_user and passwords=@p_pass; 
 
OPEN @permissionCursor;
go

如何在.net中调用此过程
感谢您的帮助
ps.我需要关闭此光标或此光标已自动关闭

[edit]已添加代码块，忽略HTML ..."选项已禁用-OriginalGriff [/edit]

how i can call this procedure in .net
thanks for any help
ps . i need to close this cursor or this cursor is closed automatic

[edit]Code block added, "Ignore HTML..." option disabled - OriginalGriff[/edit]

推荐答案

如果您使用的是SQL Server，则不要这样做"需要一个游标作为输出.您可以直接返回记录集.
不知道为什么需要显式游标作为输出.

If you are using SQL server then you don''t need a cursor as output. you can directly return the recordset.
not sure why you need explicit cursor as output.

PROCEDURE  [dbo].[get_user_pern]
(@p_user nvarchar(200)  , @p_pass nvarchar(50))
AS
      SELECT *
      FROM users_hor
    where user_names=@p_user and passwords=@p_pass;
go

您可以在数据集或日期读取器中检索该数据.

you can retreive this in dataset or datereader..

这篇关于我如何调用过程具有CURSOR VARYING OUTPUT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！