If the database table contains this id than it update the data if not contain it insert a new record which are not in table I am writing this for my requirement ,you can also change the input parameter as per your requirement. DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `USP_Update_ServiceTask`( in in_Action varchar(10), in PKService_Task_ID int, in in_serviceid int, in in_TaskIds varchar(8000), in in_Updatedby varchar(50), out message ...
Comments
Post a Comment