ALTER PROCEDURE dbo.GetMaxTaskNo ( @project_id int, @RETURN_VALUE int OUTPUT ) AS SELECT @RETURN_VALUE=max(isNull(task_no,0)) AS "MaxTaskNo" FROM task_header WHERE project_id = @project_id RETURNThen in .NET you call the stored procedure like the following:
SqlCommand cmd = new SqlCommand("GetMaxTaskNo",conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add["@project_id",SqlDbType.Int,8]; cmd.Parameters.Add["@RETURN_VALUE",SqlDbType.Int,8]; cmd.Parameters["@RETURN_VALUE"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); Console.WriteLine(cmd.Parameters["@RETURN_VALUE"].Value);>All
>ALTER PROCEDURE dbo.GetMaxTaskNo >( > @project_id int >) >AS >SELECT max(isNull(task_no,0)) AS "MaxTaskNo" > FROM task_header > WHERE project_id = @project_id > > RETURN >