ALTER proc [dbo].XYZ @EM varchar(100),@FY varchar(100),@AL numeric(18,2), @EL numeric(18,2),@BL numeric(18,2),@OE varchar(100) as declare @count int select @count=count(*) from Table1 where OE=@OE and FY=@FY if(@count>0) begin Print 'Record Already Exists' end else begin insert into Table1 (OE,FY,AL,EL,@BL,ActionDate) values(@OE,@FY,@AL,@EL,BL,getdate()) Print 'Record Saved Successfully' end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)