I have the following table
Data --Table name
ID -- Identity column
PCode -- Postal Code
CREATE TRIGGER Trig
Select * from inserted
INSERT INTO Data VALUES (125)
INSERT INTO Data VALUES (126)
INSERT INTO Data VALUES (127)
You can not. From the Use the inserted and deleted Tables article on microsoft.com, you can read:
The inserted table stores copies of the affected rows during INSERT and UPDATE statements.
That means that the
inserted table will only contain rows for the current
If you do want to see all rows for several such
UPDATE statements, you will have to store these rows in a table you created yourself.