CREATE PROCEDURE PROCEDURE_NAME ( @Trans_Type VARCHAR(100), --whatever u want u add parameters on here ) AS BEGIN IF @Trans_Type='INSERT' BEGIN --UR INSERT QUERY END ELSE IF @Trans_Type='UPDATE' BEGIN --UR UPDATE QUERY END END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)