Your question the idea of great

Why is no one to help me, because I was in China do? Or do not think my English is wrong about this?

Your question is very interesting Proposed to use " " handle a little better, you say?

http://msdn.microsoft.com/zh-cn/library/ms178340(VS.80).aspx[^] http://msdn.microsoft.com/en-us/library/ms178340(VS.80).aspx[^]

Do we have a little nice. Net framework, such as: Castle, NHiBernate If it is a better ORM Thanks ;)

SqlCommand sampleCMD = new SqlCommand("SampleProc", nwindConn); sampleCMD.CommandType = CommandType.StoredProcedure; SqlParameter sampParm = sampleCMD.Parameters.Add("RETURN_VALUE", SqlDbType.Int); sampParm.Direction = ParameterDirection.ReturnValue; sampParm = sampleCMD.Parameters.Add("@InputParm", SqlDbType.NVarChar, 12); sampParm.Value = "Sample Value"; sampParm = sampleCMD.Parameters.Add("@OutputParm", SqlDbType.NVarChar, 28); sampParm.Direction = ParameterDirection.Output; nwindConn.Open(); SqlDataReader sampReader = sampleCMD.ExecuteReader(); Console.WriteLine("{0}, {1}", sampReader.GetName(0), sampReader.GetName(1)); while (sampReader.Read()) { Console.WriteLine("{0}, {1}", sampReader.GetInt32(0), sampReader.GetString(1)); } sampReader.Close(); nwindConn.Close(); Console.WriteLine(" @OutputParm: {0}", sampleCMD.Parameters["@OutputParm"].Value); Console.WriteLine("RETURN_VALUE: {0}", sampleCMD.Parameters["RETURN_VALUE"].Value);

CREATE PROCEDURE [dbo].[Proc_Scenario_GetMaxID] ( @MaxID int OUTPUT ) as if exists(SELECT [ID] FROM student) SELECT @MaxID = MAX(ID) FROM student else SET @MaxID=1 ---------------------------- Because '@MaxID' is OUTPUT So Your stored procedure... :) ---------------------------- Chinese programmers: 狼人软件