怎样接收SCOPE_IDENTITY()返回的值??

Question

<P>&nbsp;有这样一个存储过程:<BR>set ANSI_NULLS ON<BR>set QUOTED_IDENTIFIER ON<BR>go<BR>ALTER PROCEDURE [dbo].[sp_Question_Insert] <BR>(<BR>&nbsp;@question_id bigint,<BR>&nbsp;@Content Ntext<BR>&nbsp;)<BR>AS<BR>begin<BR>SET NOCOUNT ON;<BR>&nbsp;INSERT INTO [Question] (<BR>&nbsp;&nbsp;&nbsp; [version_id],<BR>&nbsp;&nbsp;&nbsp; [content]) <BR>&nbsp;&nbsp;&nbsp; values (<BR>&nbsp;&nbsp;&nbsp; @versionid,<BR>&nbsp;&nbsp;&nbsp; @Content)<BR>SET @question_id = SCOPE_IDENTITY()</P> <P>SCOPE_IDENTITY()<FONT size=2>返回为当前会话和当前作用域中的任何表最后生成的标识值,这个值我想在CS文件里接收,怎么接收呢??</FONT></P>

Answer 1

使用存储过程的Output参数就行，修改question_id为输出参数，如： @question_id bigint output 在代码中也要指定参数的方向： SqlParameter para = new SqlParameter("@question_id",null); para.Direction = ParameterDirection.Output; 这样跟据para.Value就可以获取值了。