.Net调用存储过程(有传入、传出、返回值、记录集)及SqlDataAdapter、ExecuteNonQuery、SqlDataReader、ExecuteScalar
2009-11-10 11:02 cnb_mtime 阅读(251) 评论(0) 编辑 收藏 举报存储过程------------------------------------------------------------------------------------------------
CREATE PROCEDURE dbo.sptestList
@strOptions varchar(200) = NULL,
@intID int = NULL,
@strOut nvarchar(50) = NULL OUTPUT
AS
SET NOCOUNT ON--不返回影响的行数
SET ANSI_WARNINGS OFF--不返警告
/**//* 信息列表 */
IF @strOptions='LIST' BEGIN
SELECT
id,
name,
subject,
Source
FROM test
WHERE ID <=@intID
SET @strOut = @strOut + 'out'
RETURN 50
END
GO
-------------------------------------------------------------------------
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/huangweizhi/archive/2008/08/19/2796526.aspx