SQL SERVER SISTEMI KASMADAN SILME WHILE

 DECLARE @Rowcount INT = 1 WHILE @Rowcount > 0 BEGIN DELETE TOP (50000)   FROM  LG_013_01_PAYTRANS where ORGLOGOID LIKE 'TNYF%'
  SET @Rowcount = @@ROWCOUNT
END