存储过程 与 SQL Server语句大比拼

CREATE PROCEDURE dbo.AXzhz
/*
  @parameter1 用户名
  @parameter2 新密码
*/
@passWord nvarchar(20),
@userName nvarchar(20)
AS
declare @err0 int
update WL_user set password=@password where UserName=@userName
set @err0=@@error 
select  @err0 as err0

public static string GetCustomerCName()
        {
            SQLConnection con=ADConnection.createConnection();
            
            SQLCommand cmd=new SQLCommand("AXzhz",con);
            cmd.CommandType=CommandType.StoredProcedure;
            para0=new SQLParameter("@startDate","2006-9-10");
            para1=new SQLParameter("@endDate","2006-9-20");
            da.SelectCommand.Parameters.Add(para0);
            da.SelectCommand.Parameters.Add(para1); 
            con.Open();
            try
            {
               Int32 re=(int32)cmd.ExecuteScalar(); 
                con.Close(); 
                if (re==0)
                 return "OK!";
                else
                 return "false";
            }
            catch(Exception ex)
            {
                con.Close();
                return ex.ToString();
            }
        }

ALTER PROCEDURE dbo.selectCustomerCNameCount
@customerID int
AS
if @customerID=-1
 begin
 select contentownerid ,userCName,count(*) 
as countAll from view_usercomment group by 
contentownerid,userCName order by contentownerid DESC
 end
else
 begin
 select contentownerid ,userCName,count(*) 
as countAll from view_usercomment where 
contentownerid=@customerID group by contentownerid
,userCName order by contentownerid DESC
 end