SELECT @@IDENTITY

SELECT SCOPE_IDENTITY()

INSERT INTO T OUTPUT INSERTED.ID VALUES(...)

CREATE VIEW dbo.vw_ScrapReason
AS (SELECT ScrapReasonID, Name, ModifiedDate
    FROM Production.ScrapReason);
GO

CREATE TRIGGER dbo.io_ScrapReason 
    ON dbo.vw_ScrapReason
INSTEAD OF INSERT
AS
BEGIN
    INSERT INTO Production.ScrapReason (Name, ModifiedDate)
        OUTPUT INSERTED.ScrapReasonID, INSERTED.Name, 
               INSERTED.ModifiedDate
    SELECT Name, getdate()
    FROM inserted;
END
GO

INSERT vw_ScrapReason (ScrapReasonID, Name, ModifiedDate)
VALUES ( 99 , N'My scrap reason', '20030404');
GO