Create Procedure sp_proddtl
@vouno int,
@prodid int,
@prodamt float
AS
BEGIN TRANSACTION T1
BEGIN TRY
DELETE FROM ProdDtl WHERE vouno=1
INSERT INTO ProdDtl VALUES(@vouno,@prodid ,@prodamt )
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION T1
END CATCH
COMMIT TRANSACTION T1