DELIMITER //
create procedure duplicat(IN stName longtext,IN stmobile longtext,IN stfather longtext,IN stemail longtext)
begin
Select Auto_No from tblname where Data_As_Duplicate is null and ucase(Student_Name_AlphabetShort)=stName and (studentMobileNumber=stmobile or lcase(studentEmailID)=stemail ) and ucase(Parent_Name_AlphabetShort)=stfather order by Auto_No ;
end//
DELIMITER ;
call duplicat('nishant', '7503485910','sdk','nishant70417@live.com')
create procedure duplicat(IN stName longtext,IN stmobile longtext,IN stfather longtext,IN stemail longtext)
begin
Select Auto_No from tblname where Data_As_Duplicate is null and ucase(Student_Name_AlphabetShort)=stName and (studentMobileNumber=stmobile or lcase(studentEmailID)=stemail ) and ucase(Parent_Name_AlphabetShort)=stfather order by Auto_No ;
end//
DELIMITER ;
call duplicat('nishant', '7503485910','sdk','nishant70417@live.com')
No comments:
Post a Comment