CREATE PROCEDURE DuplicationCheckAccountLedger (IN aname varchar(50), OUT errflag bit, OUT errFieldName varchar(10)) BEGIN declare cnt int default 0; select count(name) into cnt from account_ledger where name = aname; if cnt = 0 then set errflag = 0; set errFieldName = 'none'; else set errflag = 1; set errFieldName = 'name'; end if; end //
select count(1) into cnt from account_ledger where account_ledger.name = aname;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)