例1

CREATE PROCEDURE p_out

@a as int,

@b as int,

@c as int output

AS

set @c=@a+@b

return '10'

－－－－－－－－－－－－－－－－－－－－－

.........

SqlCommand cmd2=new SqlCommand("p_out",conn);

cmd2.CommandType=CommandType.StoredProcedure;

cmd2.Parameters.Add("@a",SqlDbType.Int);

cmd2.Parameters.Add("@b",SqlDbType.Int);

SqlParameter para_c=cmd2.Parameters.Add("@c",SqlDbType.Int);

SqlParameter para_r=cmd2.Parameters.Add("returnvalue",SqlDbType.Int);

cmd2.Parameters[0].Value=2;

cmd2.Parameters[1].Value=3;

para_c.Direction=ParameterDirection.Output;

para_r.Direction=ParameterDirection.ReturnValue;

conn.open();

cmd2.ExecuteNonQuery();

conn.close();

this.Response.Write(para_c.value.ToString());

this.Response.Write(para_r.value.ToString());

例2

[@more@]