you can do this by stored procedure as
CREATE PROCEDURE proc_delete_item
@ItemCode int,
AS
SET NOCOUNT off
DECLARE @LocalError int
BEGIN TRANSACTION
DELETE FROM ITEMMAST where ItemCode=@ItemCode
DELETE FROM SAUDAMAST where ItemCode=@ItemCode
DELETE FROM PITBROK where ItemCode=@ItemCode
SELECT @LocalError = @@Error
IF NOT @LocalError = 0
BEGIN
ROLLBACK TRANSACTION
SELECT Error = @LocalError
END
ELSE
BEGIN
COMMIT TRAN
SELECT Error = 0
END