I am trying to create an INSTEAD OF INSERT trigger for a view. The base table has an auto-incremented identity column. Intuitively, I would like to write the following statement:

INSERT INTO basetable (col2, col3, col4) VALUES (SELECT col2, col3, col4 FROM Inserted)

Unfortunately, that statement is not allowed in SQL2000. Can anyone suggest the correct way to do this or point me in the right direction?

TIA,

Keith Payne