sql server2005·µ»ØÖµÎÊÌâ

(1)¹ØÓÚ´æ´¢¹ý³Ì·µ»ØÖµÎÊÌ⣨output,ruturn£©
  output´æ´¢¹ý³Ì£º
  
alter proc usp_update
@count int output
as
set @count=(select count(*) from stu)
   
 return´æ´¢¹ý³Ì£º
alter proc usp_update
as
declare @count int
set @count=(select count(*) from stu)
return @count
  
.net´úÂ루output£©£º
        SqlConnection con = new SqlConnection        ("server=95F188CF1A24424;uid=jinzhiyuan;pwd=jinzhiyuan;database=student");
        con.Open();
        SqlCommand cmd = new SqlCommand("usp_update",con);
        cmd.Parameters.Add("@count", SqlDbType.Int);
        cmd.CommandType = CommandType.StoredProcedure;
     
        cmd.Parameters["@count"].Direction = ParameterDirection.Output;
        cmd.ExecuteNonQuery();
      
        int j=(int)cmd.Parameters["@count"].Value;
        Response.Write("ÎÒÊǸողÅÖ´ÐеÄÖµ£º"+j);
        con.Close();
.net´úÂ루return£©
        SqlConnection con = new SqlConnection("server=95F188CF1A24424;uid=jinzhiyuan;pwd=jinzhiyuan;database=student");
        con.Open();
        SqlCommand cmd = new SqlCommand("usp_update",con);
        cmd.Parameters.Add("@count", SqlDbType.Int);
        cmd.CommandType = CommandType.StoredProcedure;
     
        cmd.Parameters["@count"].Direction = ParameterDirection.Ret