детский тренер
Форумчанин
Регистрация: 08.06.2007
Сообщений: 532
|
вставка в тело тригера INTITY_INSERT
Уважаеміе,подскаєите кто-нибудь....Как мне влепить
Set INTITY_insert [] on
go
в тригер..просто обязательно после INTITY лепить Go , а если его влепить, то прерівается віполнеие тригера!
Код:
CREATE TRIGGER t_L_ZAR_STATE_InsUpd
ON L_ZAR_STATE
AFTER INSERT, UPDATE
AS
BEGIN
-- update L_ZAR_TABEL set
-- L_ZAR_TABEL.nId_TypeDoc=0,
-- L_ZAR_TABEL.nId_Tablic=0,
-- L_ZAR_TABEL.nRef_Record=0,
-- L_ZAR_TABEL.cId_CodeName=isnull(LD_ZAR_FORMNORM.cId_CodeName,''),
-- L_ZAR_TABEL.nId_User=deleted.nId_User,
-- L_ZAR_TABEL.dDateLast=getdate()
-- from L_ZAR_TABEL, deleted, LD_ZAR_FORMNORM
-- where deleted.nId_TypeDoc in (2,7,8,9,10,11,12,13,14,15,36)
-- and deleted.nId_TypeDoc=L_ZAR_TABEL.nId_TypeDoc
-- and deleted.nRef_Record=L_ZAR_TABEL.nRef_Record
-- and L_ZAR_TABEL.nId_Graf*=LD_ZAR_FORMNORM.nId_Graf
-- and L_ZAR_TABEL.nDayOrder*=LD_ZAR_FORMNORM.nDayOrder
update L_ZAR_TABEL set
L_ZAR_TABEL.nId_TypeDoc=0,
L_ZAR_TABEL.nId_Tablic=0,
L_ZAR_TABEL.nRef_Record=0,
L_ZAR_TABEL.cId_CodeName=isnull(LD_ZAR_FORMNORM.cId_CodeName,''),
L_ZAR_TABEL.nId_User=deleted.nId_User,
L_ZAR_TABEL.nGod=dbo.f_ZAR_OriginalGodTabel(L_ZAR_TABEL.dDate, deleted.nId_TypeDoc , L_ZAR_TABEL.nId_Graf , L_ZAR_TABEL.nGod , L_ZAR_TABEL.nId_Tabel),
L_ZAR_TABEL.dDateLast=getdate()
from L_ZAR_TABEL, deleted, LD_ZAR_FORMNORM, L_ZAR_TABEL_SUM
-- where deleted.nId_TypeDoc in (2,7,8,9,10,11,12,13,14,15,36)
where deleted.nId_TypeDoc in (2,8,9,10,11,12,13,14,36,40)
and deleted.nId_TypeDoc=L_ZAR_TABEL.nId_TypeDoc
and deleted.nRef_Record=L_ZAR_TABEL.nRef_Record
and L_ZAR_TABEL.nId_Graf*=LD_ZAR_FORMNORM.nId_Graf
and L_ZAR_TABEL.nDayOrder*=LD_ZAR_FORMNORM.nDayOrder
and deleted.nId_Person=L_ZAR_TABEL_SUM.nId_Person
and L_ZAR_TABEL_SUM.nId_Tabel_Sum=L_ZAR_TABEL.nId_Tabel_Sum
and (L_ZAR_TABEL.dDate between deleted.dDateFrom
and isnull(deleted.dDateTo,dateadd(day,-1,dateadd(day,-day(dateadd(month,1,deleted.dDateFrom))+1,dateadd(month,1,deleted.dDateFrom))) ))
--------------new
delete L_ZAR_TABEL_ORG from L_ZAR_TABEL_ORG, L_ZAR_TABEL, L_ZAR_TABEL_SUM, deleted
where deleted.nId_TypeDoc in (2,8,9,10,11,12,13,14,36,40)
-- and deleted.nId_TypeDoc=L_ZAR_TABEL.nId_TypeDoc
-- and deleted.nRef_Record=L_ZAR_TABEL.nRef_Record
and deleted.nId_Person=L_ZAR_TABEL_SUM.nId_Person
and L_ZAR_TABEL_SUM.nId_Tabel_Sum=L_ZAR_TABEL.nId_Tabel_Sum
and (L_ZAR_TABEL.dDate between deleted.dDateFrom
and isnull(deleted.dDateTo,dateadd(day,-1,dateadd(day,-day(dateadd(month,1,deleted.dDateFrom))+1,dateadd(month,1,deleted.dDateFrom))) ))
and L_ZAR_TABEL.nId_Tabel=L_ZAR_TABEL_ORG.nId_Tabel
-- select * from L_ZAR_TABEL_ORG
-- delete from L_ZAR_TABEL_ORG
------------- ВОТ СЮДА
insert into L_ZAR_TABEL_ORG
select L_ZAR_TABEL.* from L_ZAR_TABEL, L_ZAR_TABEL_SUM, inserted, LD_ZAR_TIMEDOC
-- where deleted.nId_TypeDoc in (2,8,9,10,11,12,13,14,15,36,40)
where inserted.nId_TypeDoc in (2,8,9,10,11,12,13,14,36,40)
and inserted.nState>=0
and L_ZAR_TABEL_SUM.nId_Person=inserted.nId_Person
-- and L_ZAR_TABEL_SUM.dDateOrder=inserted.dDate
and L_ZAR_TABEL_SUM.nId_Tabel_Sum=L_ZAR_TABEL.nId_Tabel_Sum
and (L_ZAR_TABEL.dDate between inserted.dDateFrom
and isnull(inserted.dDateTo,dateadd(day,-1,dateadd(day,-day(dateadd(month,1,inserted.dDateFrom))+1,dateadd(month,1,inserted.dDateFrom))) ))
and LD_ZAR_TIMEDOC.nId_TypeDoc=inserted.nId_TypeDoc
and LD_ZAR_TIMEDOC.nId_Graf=L_ZAR_TABEL.nId_Graf and LD_ZAR_TIMEDOC.bMain=1
end
Я злой и страФный серррый воФк, и в пАрАсятах знаю толк - ppp ppp pp p pp pp
|