You can include your delete statements in a transaction so that if anything goes wrong with any of the grouped statements, all changes will be aborted.
Here is how you will do it.
BEGIN TRY
BEGIN TRANSACTION
DECLARE @Id INT
SET @Id = 1
DELETE FROM tblC WHERE ID = @Id
DELETE FROM tblB WHERE ID = @Id
DELETE FROM tblA WHERE ID = @Id
COMMIT TRANSACTION
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
END CATCH