Viewing post 1 (of 2 total)
There are other issues with your trigger
SET @IDinserito =
(SELECT ID
FROM inserted)
Assumes the inserted table will only have one row of data. Triggers should always be written from the perspective...
May 10, 2007 at 1:51 am
#705433