cmd.Parameters["@message"].Direction = System.Data.ParameterDirection.Output; cmd.ExecuteNonQuery(); retvalue = cmd.Parameters["@message"].Value.ToString(); con.Close(); return retvalue;SQL:-creator by taffy CREATE PROCEDURE updateKPIAIM ( @id int, @Message varchar(50) output ) AS SET XACT_ABORT ON BEGIN TRANupdate KPIAIM set status=1 where [id]=@id if exists(select * from aimmanagement where emid=@emid and kpitime=@kpibegin set @Message='提交成功!' endCOMMIT TRAN GO
retvalue = cmd.Parameters["@message"].Value.ToString();
con.Close();
return retvalue;SQL:-creator by taffy
CREATE PROCEDURE updateKPIAIM
( @id int,
@Message varchar(50) output
)
AS
SET XACT_ABORT ON
BEGIN TRANupdate KPIAIM set status=1 where [id]=@id
if exists(select * from aimmanagement where emid=@emid and kpitime=@kpibegin
set @Message='提交成功!'
endCOMMIT TRAN
GO