sql – 从存储过程返回多个值

我想从第一个存储过程返回多个值.

例如：我从Master_SP调用Sub_SP. Sub_SP将向Master_SP返回多个值.

任何人都可以举例说明OUTPUT参数吗？

谢谢.

解决方法

ALTER procedure ashwin @empid int,@empname varchar(20) output,@age int output
as
select @empname=ename,@age=age
from emp where empid=@empid;

declare @ename varchar(20),@age int
execute ashwin 101,@ename out,@age out
select @ename,@age;

// ————

namespace sqlserver
{
    class Program
    {
        static void Main(string[] args)
        {

            createconnection();
        }
        public static void createconnection()
        {
            SqlConnection con=new SqlConnection("Data Source=ASHWINSQLEXPRESS;Initial Catalog=employee;Integrated Security=True;Pooling=False");
            con.Open();

            SqlCommand cmd=new SqlCommand("ashwin",con);
            cmd.CommandType=CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@empid",SqlDbType.Int,10,"empid"));
            cmd.Parameters.Add(new SqlParameter("@empname",SqlDbType.VarChar,20,ParameterDirection.Output,false,"ename",DataRowVersion.Default,null));
            cmd.Parameters.Add(new SqlParameter("@age","age",null));
            cmd.Parameters[0].Value = 101;
            cmd.UpdatedRowSource = UpdateRowSource.OutputParameters;
            cmd.ExecuteNonQuery();
            string name = (string)cmd.Parameters["@empname"].Value;
            int age = Convert.ToInt32(cmd.Parameters["@age"].Value);
            Console.WriteLine("the name is {0}--and age is {1}",name,age);


            Console.ReadLine();
        }
    }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!