I had already tried using temporary tables, but the problem with them is
my base table might include columns of types text, ntext, or image.
If you try the command
SELECT * INTO #inserted FROM inserted
that you suggested on a base table containing the above data types, sql
server returns the error:
Cannot use text, ntext, or image columns in the 'inserted' and 'deleted'
so you somehow need to filter-out columns of specific data-types when
inserting to the
temporary table, which brings us back to where we started. A dynamic sql
insert string has to be created