BEGIN TRANSACTION; DECLARE @isim1  VARCHAR(30) = 'ELİF EKEN', @EtkilenenSatirSayisi1  INT = -1; UPDATE ogrenci SET mahalle = concat('AYVAZHACI','|','AYVAZHACI HATTI')  WHERE CHARINDEX(isim, @isim1)>0 and  CHARINDEX(soyisim, @isim1)>0 AND okulid= 17 ; SET @EtkilenenSatirSayisi1 = @@ROWCOUNT; IF @EtkilenenSatirSayisi1 = 0 PRINT @isim1; ELSE IF @EtkilenenSatirSayisi1 > 1 BEGIN PRINT 'Mukerrer kayit: ' + @isim1; ROLLBACK; END ELSE BEGIN PRINT 'Basarili'; COMMIT; END;