mssql, опять торможу с триггером
12 © (2010-06-23 17:15:00)
пишу в триггере
---
insert into rnrTest --для проверки
select
R.*
from
rnrRequest R
join inserted i on R.IdRequest =
i.RequestId
where i.NoSubscr = 1
update R
--что надо сделать
set
R.StatusId = -100
from
rnrRequest R
join inserted i on R.IdRequest = i.RequestId
where i.NoSubscr = 1
-------
делаем запрос
select
T.IdRequest, R.StatusId
from
rnrTest T
join rnrRequest R on R.IdRequest = T.IdRequest
с результатом
51 0
почему не
51 -100
?
12 (2010-06-23 17:51:00) [1]
весь триггер
ALTER TRIGGER [dbo].[rnrAlignmentUpdate_TRGR]
ON [dbo].[rnrAlignment]
AFTER UPDATE
AS
BEGIN
IF ( trigger_nestlevel() > 1) Return;
if Exists(select inserted.Id from inserted where
inserted.Subscr = 1)
update rnrAlignment
set datatime = GetDate()
where Id in (select inserted.Id from inserted where
inserted.Subscr = 1)
if Exists(select inserted.Id from inserted where
inserted.Subscr = 0)
update rnrAlignment
set datatime = null
where Id in (select inserted.Id from inserted where
inserted.Subscr = 0)
if Exists(select inserted.Id from inserted where
inserted.NoSubscr = 1)
begin
update rnrAlignment
set datatime = GetDate()
where Id in (select inserted.Id from inserted where
inserted.NoSubscr = 1);
-- insert into rnrTest
-- select R.*
-- from rnrRequest R
-- join inserted i on R.IdRequest =
i.RequestId
-- where i.NoSubscr = 1
--
-- update R
-- set R.StatusId = -100
-- from rnrRequest R
-- join inserted i on R.IdRequest =
i.RequestId
-- where i.NoSubscr = 1
end
if Exists(select inserted.Id from inserted where
inserted.NoSubscr = 0)
update rnrAlignment
set datatime = null
where Id in (select inserted.Id from inserted where
inserted.NoSubscr = 0)
END
дано
rnrRequest.IdRequest(PK) - rnrAlignment.RequestId(FK)
На словах задача
как только A.NoSubscr = 1, сразу A.DataTime = getdate
а R.StatusId приравнять к -100 (неполучается именно
это)
Наверх 
ЧАТ |
Орешник |
|
