var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: trigger, inserted pseudo table?
I am trying to create a trigger on a table but when I check the syntax it
tells me that "The column prefix 'inserted' does not match with a table name or alias used in this query"
How do I use the inserted pseudo table?
CREATE TRIGGER trg_Structural_GenerateBarcode ON [dbo].[tbStructuralComponentSchedule]
DECLARE @iCount int, @cBarcode char (25), @cCode char(4)
DECLARE @cProject char(7), @cComponent char(10), @iEntryID int
SELECT @cProject = inserted.fkProjectNumber, @cComponent = inserted.fkComponentID, @iEntryID = inserted.EntryID
Maybe a "FROM inserted" would help?
Just FYI, a trigger fires for each SQL statement, not for each row. Be careful about assuming that only one row will be returned.
Thanks for the tip. I did not know that. I don't believe it will affect me, but definately good too know
Originally Posted by Pat Phelan