Zabrana uvoza prometa iz ranijih godina

create trigger _ZabranaGlava on rGlava
after insert
as
if exists(select * from inserted where cast (left(kljuc,2) as int) < 15)
begin
    rollback
end
go

create trigger _ZabranaPozicije on rPozicije
after insert
as
if exists(select * from inserted where cast (left(kljuc,2) as int) < 15)
begin
    rollback
end

----------------------------------------------------------------------------

PANTHEON

-----------------------------------------------------------------------------

CREATE trigger [dbo].[_ZabranaMove] on [dbo].[tHE_Move]
after insert, update
as

if dbo.fPA_GetConInfoRC(2) = 1
return

if exists(select * from inserted where cast (left(acKey,2) as int) < 18)
begin
raiserror('ZAKLJUCANO RAZDOBLJE (INSERT, UPDATE)', 16, 1)
rollback
end
GO

CREATE trigger [dbo].[_ZabranaMoveD] on [dbo].[tHE_Move]
after delete
as

if dbo.fPA_GetConInfoRC(2) = 1
return

if exists(select * from deleted where cast (left(acKey,2) as int) < 18)
begin
raiserror('ZAKLJUCANO RAZDOBLJE (DELETE)', 16, 1)
rollback
end
GO

CREATE trigger [dbo].[_ZabranaMoveItem] on [dbo].[tHE_MoveItem]
after insert, update
as

if dbo.fPA_GetConInfoRC(2) = 1
return

if exists(select * from inserted where cast (left(acKey,2) as int) < 18)
begin
raiserror('ZAKLJUCANO RAZDOBLJE (INSERT, UPDATE)', 16, 1)
rollback
end
GO

create trigger [dbo].[_ZabranaMoveItemD] on [dbo].[tHE_MoveItem]
after delete
as

if dbo.fPA_GetConInfoRC(2) = 1
return

if exists(select * from deleted where cast (left(acKey,2) as int) < 18)
begin
raiserror('ZAKLJUCANO RAZDOBLJE (BRISANJE)', 16, 1)
rollback
end
GO