56,687
社区成员
发帖
与我相关
我的任务
分享
create procedure myProc(v_JQ varchar(50),out flg int)
begin
declare SYID,JQID,MyNewId int default 0;
set flg=1;
select id into JQID from insorder where insDocumentId=v_JQ and `status`='新数据' limit 0,1;
set flg=JQID;
end
……
Cmd.CommandText = "pop_test";
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters[0].Direction = ParameterDirection.Output;
if (Cmd.Connection.State == 0)
Cmd.Connection.Open();
Cmd.ExecuteNonQuery();
label1.Text += Cmd.Parameters[0].Value + "\r\n";