ВО
Size: a a a
ВО
JM
declare @maxId int
,@deleted int;
set @deleted = 0;
set @maxId = (select MAX(transactionid)
FROM dbo.octransaction)
if @maxId > 1000000000
BEGIN
delete from octransaction
where transactionid < 500000000
SET @r = @@ROWCOUNT;
SET @deleted = @deleted + @r;
DBCC CHECKIDENT ('octransaction', RESEED, 0);
END
SC
declare @maxId int
,@deleted int;
set @deleted = 0;
set @maxId = (select MAX(transactionid)
FROM dbo.octransaction)
if @maxId > 1000000000
BEGIN
delete from octransaction
where transactionid < 500000000
SET @r = @@ROWCOUNT;
SET @deleted = @deleted + @r;
DBCC CHECKIDENT ('octransaction', RESEED, 0);
END
JM
SC
ВE
declare @maxId int
,@deleted int;
set @deleted = 0;
set @maxId = (select MAX(transactionid)
FROM dbo.octransaction)
if @maxId > 1000000000
BEGIN
delete from octransaction
where transactionid < 500000000
SET @r = @@ROWCOUNT;
SET @deleted = @deleted + @r;
DBCC CHECKIDENT ('octransaction', RESEED, 0);
END
JM
АК
ВE
АК
ВE
ВE
СЛ
IP
СЛ
СЛ
ВE
IP
А